5

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for computer enthusiasts and power users

DECLARE @user INT = ##UserID:int##

select
    Answer.Id as [Post Link],
    Answer.Score,
    CASE WHEN Answer.Score >= 20 then 'Reversal!' else CAST(CONVERT(INT, CAST(Answer.Score as float) * 100 / 20) as VARCHAR(2)) + '%' END as Progress
FROM Posts as Answer
LEFT JOIN Posts as Question on Answer.ParentId=Question.Id
WHERE Answer.OwnerUserId=@user and Question.Score <= -5
ORDER BY Answer.Score DESC

fork query

edited aug 14 12

created aug 14 12 Brad Mace