Progress towards Commentator, Pundit

0

Please login or register to vote for this query.

(click on this box to dismiss)

10 comments needed for Commentator, 10 with score >= 5 for Pundit

Lifehacks

Q&A for people looking to bypass life's everyday problems with simple tricks

select TOP 50
    Posts.Id as [Post Link],
    Comments.Score,
    CAST(CONVERT(INT, CAST(Comments.Score as float) * 20) as VARCHAR(5)) + '%' as PunditProgress
FROM Comments, Posts
WHERE Comments.UserId=##UserID:int## and Posts.Id = Comments.PostId
ORDER BY Comments.Score DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results