Advertisement
Guest User

Untitled

a guest
Jul 18th, 2019
110
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. DECLARE @CurrentWeekDay INT
  2.  
  3. SET DATEFIRST 1
  4. SET @CurrentWeekDay = DATEPART (WEEKDAY, GETDATE()) - 1
  5.  
  6. DECLARE @TotalHolidays INT, @IsSameWeek BIT
  7.  
  8.  
  9. SET @IsSameWeek =
  10. CASE
  11. WHEN (SELECT DATEDIFF(WEEK,GETDATE(), (SELECT TOP 1 DataFim FROM hFeriados))) = -1 THEN 0
  12. ELSE
  13. 1
  14. END
  15.  
  16. SET @TotalHolidays =
  17. CASE
  18. WHEN @IsSameWeek = 1 THEN (SELECT DATEDIFF(day, Start, End) FROM Holidays)
  19. ELSE
  20. 0
  21. END
  22.  
  23. DECLARE @TotalDays = 5,
  24. SET @TotalDays = @TotalDays - @TotalHolidays - @CurrentWeekDay
  25.  
  26. Datefirst
  27. M T W T F
  28. 0 1 2 3 4
  29.  
  30. M T W T F
  31. 0 1 2 3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement