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

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##
ORDER BY Comments.Score DESC

fork query

edited oct 30 12 anonymous

created aug 14 12 Brad Mace