List comments in order of score
Q&A about the site for members of the workforce navigating the professional setting
-- How long until I get the pundit badge? -- List comments in order of score DECLARE @UserId int = ##UserId## SELECT TOP 20 Posts.Title, Comments.Text, Comments.Score, Posts.Id, Posts.ParentId FROM Comments INNER JOIN Posts ON Comments.PostId = Posts.Id WHERE UserId = @UserId ORDER BY Score DESC