0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT
  CAST(CAST(DATEPART(yyyy, v.CreationDate) AS NVARCHAR(4)) + '-' + CAST(DATEPART(mm, v.CreationDate) AS NVARCHAR(2)) + '-01' AS DATETIME) AS [Date],
  Count (CASE v.VoteTypeId WHEN 1 THEN 1 END) AS [Accept],
  Count (CASE v.VoteTypeId WHEN 2 THEN 1 END) AS [Up],
  Count (CASE v.VoteTypeId WHEN 3 THEN 1 END) AS [Down]
FROM Votes v
WHERE v.UserId = ##user##
GROUP BY CAST(CAST(DATEPART(yyyy, v.CreationDate) AS NVARCHAR(4)) + '-' + CAST(DATEPART(mm, v.CreationDate) AS NVARCHAR(2)) + '-01' AS DATETIME)
ORDER BY Date ASC

view current version

edited dec 23 14

created dec 23 14 Gilles