Given that there is no way of telling what a holiday is then no. You also have to decide what you mean by a holiday - country....CREATE FUNCTION fn_CalcBusinessDay (@date datetime , -- start date@interval int , -- No of days, plus or minus@country varchar(50))returns datetime AS begindeclare @daysAdded int , @newDate datetime select @daysAdded = 0 , @newDate = @date while @daysAdded < abs(@interval) begin if @interval > 0 begin select @newDate = DateAdd(d, 1, @newDate) end else begin select @newDate = DateAdd(d, -1, @newDate) end if dbo.fn_IsHolidayDay(@country, @newDate) = 0 and dbo.fn_CQS_IsWeekend(@newDate) = 0 select @daysAdded = @daysAdded + 1 end return @newDate end
==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.