CREATE TABLE [dbo].[MS_Holiday] (
	[Holiday_Depot_No] [varchar] (7) COLLATE Latin1_General_CI_AI NOT NULL ,
	[Holiday_Dt] [datetime] NOT NULL ,
	[Holiday_Desc] [varchar] (40) COLLATE Latin1_General_CI_AI NOT NULL 
) ON [SECONDARY]

CREATE FUNCTION dbo.GetNextBusinessDay (@Date datetime,
                                        @DaysToAdd int)
RETURNS datetime

/* Name:    GetNextBusinessDay
 *
 * Purpose: Calculate business days from a particular date.  @DaysToAdd can be positive or negative.
 *
 * Modification History:
 *  03/20/2009  VRI  Derived from http://www.sqlservercentral.com/Forums/Topic228794-253-2.aspx "Jason"
 *
 */

AS
BEGIN

    DECLARE @DayCounter int,
            @Sign int

    SET @DayCounter = 0 

    SET @Sign = SIGN(@DaysToAdd)

    WHILE (@DayCounter < ABS(@DaysToAdd))
    BEGIN

        SET @Date = DATEADD(dd, @Sign, CONVERT(datetime, (CONVERT(CHAR(10), @Date, 101))))

        WHILE ((@@DATEFIRST + DATEPART(dw, @Date) - 1) % 7) + 1 IN (1, 7) 
          OR  @Date IN (SELECT  HolidayDate 
                                FROM  Holiday) 
              SET @Date = DATEADD(dd, @Sign, @Date)
        
        SET @DayCounter = @DayCounter + 1

    END
    
    RETURN @Date
END