--A GROUP BY CASE variable for daily, weekly and quarterly Data
-- This code should be executed on AdventureWorks2005 or 2008 as it uses table Sales.SalesOrderHeader
Copy and paste code below into Adventure Works
-- declare variables. Change the values taking them from 1 to 4 i.e.
-- 1 is for daily data
-- 2 is for weekly data
-- 3 is for monthly data
-- 4 is for quarterly data