The 50 highest ranked comments with post links
Q&A about the site for aircraft pilots, mechanics, and enthusiasts
-- 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