quote:

---

Originally posted by Peso

SELECT MAX(Date) FROM (
SELECT TOP(50) f.Date
FROM F_TABLE_DATE('20091116', '2099116') AS f
WHERE WEEKDAY_NAME NOT IN ('Sat', 'Sun')
AND f.Date NOT IN (SELECT x.HolidayDate FROM DbHolidays AS x)
ORDER BY f.Date
) AS d

---

N 56°04'39.26"
E 12°55'05.63"

---

[dbo].[AddWorkDays] 
(    
    @WorkingDays As Int, 
    @StartDate AS DateTime 
) 
RETURNS DateTime 
AS 
BEGIN 
    DECLARE @Count AS Int 
    DECLARE @i As Int 
    DECLARE @NewDate As DateTime 
    SET @Count = 0 
    SET @i = 0 

    WHILE (@i < @WorkingDays) --runs through the number of days to add 
    BEGIN 
-- increments the count variable 
        SELECT @Count = @Count + 1 
-- increments the i variable 
        SELECT @i = @i + 1 
-- adds the count on to the StartDate and checks if this new date is a Saturday or Sunday 
-- if it is a Saturday or Sunday it enters the nested while loop and increments the count variable 
           WHILE DATEPART(weekday,DATEADD(d, @Count, @StartDate)) IN (1,7) 
            BEGIN 
                SELECT @Count = @Count + 1 
            END 
    END 

-- adds the eventual count on to the Start Date and returns the new date 
    SELECT @NewDate = DATEADD(d,@Count,@StartDate) 
    RETURN @NewDate 
END

quote:

---

Originally posted by mac_85

SELECT MAX(Date) FROM (
SELECT TOP(50) f.Date
FROM F_TABLE_DATE('20091116', '20991116') AS f
WHERE WEEKDAY_NAME NOT IN ('Sat', 'Sun')
AND f.Date NOT IN (SELECT x.HolidayDate FROM DbHolidays AS x)
ORDER BY f.Date
) AS d

---