Advertisement
Guest User

Untitled

a guest
Aug 19th, 2017
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.27 KB | None | 0 0
  1. set @start = (SELECT DATEADD(MM, DATEDIFF(MM, '01/01/2000', DATEADD(MM, -1,GETDATE())), '01/01/2000'))
  2. set @end = (SELECT DATEADD(SS,-1,DATEADD(MM, DATEDIFF(MM,'01/01/2000',GETDATE()),'01/01/2000')))
  3. set @norm = ((DateDiff(dd, @start, @end) - DateDiff(ww, @start, @end)*2)*7.4)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement