The 50 highest ranked comments with post links
Q&A for project managers
-- My Top-ranked comments -- The 50 highest ranked comments with post links DECLARE @UserId int = ##UserId## SELECT TOP 50 PostId as [Post Link], Score, Text FROM Comments WHERE UserId = @UserId ORDER BY Score DESC