We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
SELECT l.LinkID, l.NavigateURL, l.ImageFile, l.Status, isnull(l.StartDate, GetDate()) As StartDate, isnull(u.rating,0) AS Rating, isnull(o.Clicks,0) AS Clicks FROM LinkIndex l left join ( Select sum(rating) as Rating, LinkID from UserRatings group by LinkID ) u on l.LinkID = u.LinkID left join ( Select count(LinkID) as Clicks, LinkID from OutboundTraffic group by LinkID ) o on l.LinkId = o.LinkId where status in (0,1,2) and userid = 1001 order by startdate
Join the community of 500,000 technology professionals and ask your questions.