3

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

DECLARE @tagName nvarchar(35) = '##tagName##'


         SELECT 
                SUM(case votes.votetypeid 
                        WHEN 2 THEN   -- upvote
                           CASE posts.posttypeid 
                              WHEN 1 THEN 1  -- upvote question
                           END
                        WHEN 3 THEN -1  -- downvote
                 END) as Rep,
                 Votes.CreationDate AS CreationDate,
                 Posts.OwnerUserId 
          FROM   Posts
                 INNER JOIN Votes              
                   ON Votes.PostId = Posts.Id
                INNER JOIN Users ON Posts.OwnerUserId = Users.Id
                   
          WHERE ( Posts.CommunityOwnedDate IS NULL ) 
          GROUP BY Votes.CreationDate,
                    Posts.OwnerUserId

view current version

edited jun 14 16

created jun 2 16 andima