Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
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
|MS SQL Update query with connected table data||3||61|
|SQL Query incorrect syntax near the keyword ON any help would be appreciated||18||30|
|Sql case statement to calculate totals||5||34|