Listing 2: Attempt to Add MAXRECURSION Support to fn_nums Function

ALTER FUNCTION dbo.fn_nums(@max AS INT)
   RETURNS TABLE AS RETURN

WITH Nums AS
(
  SELECT 1 AS n
  UNION ALL
  SELECT n + 1 FROM Nums WHERE n < @max
)
SELECT n FROM Nums
OPTION (MAXRECURSION 0);
GO