Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @CurrentWeekDay INT
- SET DATEFIRST 1
- SET @CurrentWeekDay = DATEPART (WEEKDAY, GETDATE()) - 1
- DECLARE @TotalHolidays INT, @IsSameWeek BIT
- SET @IsSameWeek =
- CASE
- WHEN (SELECT DATEDIFF(WEEK,GETDATE(), (SELECT TOP 1 DataFim FROM hFeriados))) = -1 THEN 0
- ELSE
- 1
- END
- SET @TotalHolidays =
- CASE
- WHEN @IsSameWeek = 1 THEN (SELECT DATEDIFF(day, Start, End) FROM Holidays)
- ELSE
- 0
- END
- DECLARE @TotalDays = 5,
- SET @TotalDays = @TotalDays - @TotalHolidays - @CurrentWeekDay
- Datefirst
- M T W T F
- 0 1 2 3 4
- M T W T F
- 0 1 2 3
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement