My Comments, ordered by Score 2
Q&A for professional and enthusiast programmers
-- My Comment Score distribution -- How many comments do I have for each score. DECLARE @UserId int = ##UserId## SELECT Comments.Score, Text, CASE WHEN Q.Id is not NULL THEN Q.Title ELSE Posts.Title END as Title, PostId, Posts.ParentId, Comments.CreationDate FROM Comments join Posts on Comments.PostId = Posts.Id left join Posts as Q on Posts.ParentId = Q.Id WHERE UserId = @UserId and Comments.Score > 0 ORDER BY Comments.Score DESC