Listing 2: Code That Determines the Base Date

INSERT INTO @hold
SELECT ISODate, Dte, Year,
  FiscalYear, Quarter, Month,
  DayOfMonth, DayOfWeek,
  Monthname, DayName, Week,
  IsWeekday, IsHoliday,
  HolidayDescription,EndOf
FROM
  CALENDAR
WHERE
  dte = (DATEADD(dd, @Part2, @edate))