Dynamically generating large queries

gistfile1.txt

DECLARE @NumberOfLayers INT = 1000;

SELECT 0 AS Ordered, 'DECLARE @t TABLE (Id INT PRIMARY KEY CLUSTERED);'
UNION
SELECT 1 AS Ordered, 'WITH CTE1 AS (SELECT * FROM @t t1)'
UNION
SELECT value AS Ordered, ', CTE' + CAST(value AS VARCHAR(10)) + ' AS (SELECT cA.* ' +
  ' FROM CTE' + CAST(value - 1 AS VARCHAR(10)) + ' cA INNER JOIN ' +
  ' CTE' + CAST(value - 1 AS VARCHAR(10)) + ' cB ON cA.Id = cB.Id) '
FROM GENERATE_SERIES(2,@NumberOfLayers)
UNION
SELECT @NumberOfLayers + 1 AS Ordered, 'SELECT * FROM CTE' + CAST(@NumberOfLayers AS VARCHAR(10))
ORDER BY 1
GO