Listing 3: Code That Determines the Beginning Date for the NHNM Example

WHEN @D = 'M' THEN
  (SELECT
    MIN(dte)
  FROM
    Calendar
  WHERE
    [Month] = (SELECT [month] FROM @hold)
    AND [year] = (SELECT [year] FROM @hold))