5

Please login or register to vote for this query.

(click on this box to dismiss)

shows your accepted answers and how close they are to earning the Guru badge (accepted answer and score of 40 or more)

Q&A for professional and enthusiast programmers

select 
    Answer.Id as [Post Link],
    Answer.Score,
    CAST(CONVERT(DECIMAL(5,2), Answer.Score * 2.5)  as VARCHAR(6)) + '%' as GuruProgress
from Posts as Question
LEFT JOIN Posts as Answer on Question.AcceptedAnswerId=Answer.Id
WHERE Question.PostTypeId=1 and Answer.OwnerUserId=##UserID:int## and Answer.CommunityOwnedDate is null
ORDER BY Answer.Score DESC

fork query

edited oct 14 12

created aug 14 12 Brad Mace