Rep without rep cap [fixed with correct answer score]

1

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 
          END)
FROM Votes v
INNER JOIN Posts p ON p.ID = v.PostID
WHERE p.OwnerUserID = @UserID AND p.CommunityOwnedDate IS NULL

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results