10

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Ubuntu users and developers

-- Legendary Badge advancement
-- Retrieve how often you reached the reputation cap

DECLARE @UserId int = ##UserId##

SELECT 
    CASE VoteTypeId
        WHEN 1 THEN 15
        WHEN 2 THEN 10
        WHEN 3 THEN -2
        WHEN 8 THEN -bountyamount
        WHEN 9 THEN bountyamount
        END TargetRepChange,
    Votes.CreationDate AS Date
FROM Votes
    INNER JOIN Posts ON Posts.Id = Votes.PostId
    INNER JOIN Users ON Users.Id = Posts.OwnerUserId
WHERE VoteTypeId IN (1,2,3,8,9)
    AND Posts.OwnerUserId = @UserId
    AND Posts.CommunityOwnedDate IS NULL
--GROUP BY 
--    Votes.CreationDate
--HAVING
--    COUNT(*) >= 10
--ORDER BY 
--    Votes DESC

view current version

edited jan 2 14

created jan 2 14 zessx