2

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

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

fork query

edited dec 5 16 anonymous

created sep 29 14 Stephan Muller