Guest User

Untitled

a guest
Oct 15th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. DECLARE @StartDt AS DATE;
  2. DECLARE @EndDt AS DATE;
  3. DECLARE @Dt AS DATE;
  4. select @RDt=CASE WHEN CAST(DATEPART(DW,GETDATE()) AS INT) > 2
  5. THEN
  6. CAST(DATEADD(WK, DATEDIFF(WK,0,GETDATE()), 1) AS DATE)
  7. ELSE
  8. CONVERT(VARCHAR,DATEADD(WK,DATEDIFF(WK,6,GETDATE()),1),107) END
  9.  
  10. select @StartDt=CAST(DATEADD(WK,DATEDIFF(WK,6,@Dt),0) AS DATE)
  11. select @EndDt=CAST(DATEADD(WK,DATEDIFF(WK,6,@Dt),6) AS DATE)
Add Comment
Please, Sign In to add comment