List comments in order of score
Q&A for SharePoint enthusiasts
-- 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