SQL chart query
I would want to create a chart in Analytics that would show the amount of service requests created by week for the past 90 days or so. Since we don't have SQL2012 running, I am using the following SQL command elsewhere to stack other requests per day. Unfortunately, replacing "day" in the command by "week" gave an error.
Is there a way in SQL to stack based on the week number?
SELECT RIGHT('0' + CAST(Month(CreatedDate) as varchar(2)), 2) + RIGHT('0' + CAST(Day(CreatedDate) as varchar(2)), 2) as CompletedDate,