Archief - SQL functie

CREATE FUNCTION Optellen (@StartDate DATETIME, @Number INT) 
RETURNS DATETIME AS
BEGIN
       RETURN DATEADD(DAY, @Number, @StartDate)
END

CREATE FUNCTION Optellen (@StartDate DATETIME, @Number INT) 
RETURNS DATETIME AS
BEGIN

DECLARE @Counter INTEGER

SET @Counter = 1

WHILE @Counter <= @Number
BEGIN
      SET @StartDate = DATEADD(DAY, 1, @StartDate)
      IF (DATEPART(dw, @StartDate) != 1) AND (DATEPART(dw, @StartDate) != 7)
      BEGIN
            DECLARE @Holidays TABLE(holidayDate DATETIME)
            INSERT INTO @Holidays (holidayDate) VALUES ('2013-01-01 00:00:00')
            INSERT INTO @Holidays (holidayDate) VALUES ('2013-03-31 00:00:00')
            INSERT INTO @Holidays (holidayDate) VALUES ('2013-04-01 00:00:00')
            INSERT INTO @Holidays (holidayDate) VALUES ('2013-05-01 00:00:00')
            INSERT INTO @Holidays (holidayDate) VALUES ('2013-05-09 00:00:00')
            INSERT INTO @Holidays (holidayDate) VALUES ('2013-05-19 00:00:00')
            INSERT INTO @Holidays (holidayDate) VALUES ('2013-05-20 00:00:00')
            INSERT INTO @Holidays (holidayDate) VALUES ('2013-07-21 00:00:00')
            INSERT INTO @Holidays (holidayDate) VALUES ('2013-08-15 00:00:00')
            INSERT INTO @Holidays (holidayDate) VALUES ('2013-11-01 00:00:00')
            INSERT INTO @Holidays (holidayDate) VALUES ('2013-11-11 00:00:00')
            INSERT INTO @Holidays (holidayDate) VALUES ('2013-12-25 00:00:00')
            IF (NOT EXISTS (SELECT * FROM @Holidays h WHERE h.holidayDate = @StartDate))
            BEGIN
                  SET @Counter = @Counter +1
            END
      END
END

RETURN @StartDate

END