Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- set @start = (SELECT DATEADD(MM, DATEDIFF(MM, '01/01/2000', DATEADD(MM, -1,GETDATE())), '01/01/2000'))
- set @end = (SELECT DATEADD(SS,-1,DATEADD(MM, DATEDIFF(MM,'01/01/2000',GETDATE()),'01/01/2000')))
- set @norm = ((DateDiff(dd, @start, @end) - DateDiff(ww, @start, @end)*2)*7.4)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement