Advertisement
infogulch

Calculate the date that is N workdays from a given date

May 7th, 2012
103
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.38 KB | None | 0 0
  1. CREATE FUNCTION dbo.ufn_WorkdaysFrom(@workdays int, @start date)
  2. RETURNS DATE
  3. AS
  4. BEGIN
  5.     RETURN (SELECT TOP 1 date
  6.             FROM Calendar P
  7.             WHERE date > @start AND workday = 1 AND (
  8.                 SELECT COUNT(NULLIF(C.workday,0))
  9.                 FROM Calendar C
  10.                 WHERE C.date > @start AND C.date <= P.date
  11.                 ) = @workdays)
  12. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement