ruffyen

Untitled

Jan 10th, 2013
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.42 KB | None | 0 0
  1. DECLARE @dt DATE = '12-24-2012'
  2. SELECT Deployment, Measurement, WeekStartDate, [Num Headers], [Num Items]
  3. FROM
  4.     (SELECT
  5.         DATA.Deployment,
  6.         DATA.Measurement,
  7.         CAST(CONVERT(VARCHAR(10),DATA.DateCreated,111) AS DATE) AS "Date",
  8.         datepart(wk, DATA.DateCreated) AS weekno,
  9.         DATEADD(dd,2,DATEADD(dd, -1 * DATEPART(dw, @dt), @dt)) AS weekstartdate,
  10.         DATA.[Num Headers],
  11.         DATA.[num items]
  12.     FROM
  13.         Usage_Data DATA) a
Advertisement
Add Comment
Please, Sign In to add comment