Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @StartDt AS DATE;
- DECLARE @EndDt AS DATE;
- DECLARE @Dt AS DATE;
- select @RDt=CASE WHEN CAST(DATEPART(DW,GETDATE()) AS INT) > 2
- THEN
- CAST(DATEADD(WK, DATEDIFF(WK,0,GETDATE()), 1) AS DATE)
- ELSE
- CONVERT(VARCHAR,DATEADD(WK,DATEDIFF(WK,6,GETDATE()),1),107) END
- select @StartDt=CAST(DATEADD(WK,DATEDIFF(WK,6,@Dt),0) AS DATE)
- select @EndDt=CAST(DATEADD(WK,DATEDIFF(WK,6,@Dt),6) AS DATE)
Add Comment
Please, Sign In to add comment