1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

DECLARE @UserId int = ##UserId?209103##

SELECT 
  DATEADD(YEAR, DATEDIFF(YEAR, 0, CreationDate), 0) AS [YEAR]
  , COUNT(*) AS Count
FROM Posts
WHERE OwnerUserId = @UserId
GROUP BY DATEADD(YEAR, DATEDIFF(YEAR, 0, CreationDate), 0)
ORDER BY [YEAR] DESC

fork query

edited dec 3

created feb 8 16 Frank van Puffelen