giammin

Group by week

Sep 18th, 2012
211
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.25 KB | None | 0 0
  1. SELECT MIN(DATEADD(week, DATEDIFF(week,0,CreatedDate), 0))
  2.         ,DATEPART(week, CreatedDate)
  3.         ,YEAR(CreatedDate)
  4.         , COUNT(id)
  5. FROM [TableName]
  6. GROUP BY DATEPART(week, CreatedDate), YEAR(CreatedDate)
  7. ORDER BY YEAR(CreatedDate), DATEPART(week, CreatedDate)
Advertisement
Add Comment
Please, Sign In to add comment