Grouping records per week in SQL
I am trying to run a query to pull records per week in a year.
COuld you help create a query?.
I am using 2008 SQL.
If you want to aggregate results by week in a single year, then aggregate and group with
GROUP BY DATEPART(wk, <yourDate>), DATEPART(mm, <yourDate>)