Progress towards Reversal badge

2

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

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

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached