Rep without rep cap [fixed with correct answer score]


Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

DECLARE @UserId int = ##UserId##

SELECT SUM(Case When VoteTypeID = 1 Then 15 
                WHEN (VoteTypeID=2 AND p.PostTypeID=2) THEN 10 
                WHEN (VoteTypeID=2 AND p.PostTypeID=1) THEN 5 
                WHEN VoteTypeID=3 THEN -2 
                ELSE 0 
FROM Votes v
INNER JOIN Posts p ON p.ID = v.PostID
WHERE p.OwnerUserID = @UserID AND p.CommunityOwnedDate IS NULL

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results