The 50 highest ranked comments with post links
Q&A about the site for expert genealogists and people interested in genealogy or family history
-- 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