Rather use a recursive cte to create your numbers.

WITH cte AS (
   SELECT 1 as Num
   UNION ALL
   SELECT Num + 1 FROM cte  WHERE...