Listing 4: Code That Determines the Ending Date for the NHNM Example

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