Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @dt DATE = '12-24-2012'
- SELECT Deployment, Measurement, WeekStartDate, [Num Headers], [Num Items]
- FROM
- (SELECT
- DATA.Deployment,
- DATA.Measurement,
- CAST(CONVERT(VARCHAR(10),DATA.DateCreated,111) AS DATE) AS "Date",
- datepart(wk, DATA.DateCreated) AS weekno,
- DATEADD(dd,2,DATEADD(dd, -1 * DATEPART(dw, @dt), @dt)) AS weekstartdate,
- DATA.[Num Headers],
- DATA.[num items]
- FROM
- Usage_Data DATA) a
Advertisement
Add Comment
Please, Sign In to add comment