Execute the following Microsoft SQL Server Transact-SQL (T-SQL) script in Management Studio (SSMS) Query Editor, SQLCMD or other client software to generate a sequence of 256 numbers. The script is using cascading CTE-s: Seq1, Seq2, Seq3, Seq4 and cteSequence.

USE AdventureWorks;

WITH

       Seq1 AS (SELECT 1 AS Number UNION ALL SELECT 1),

       Seq2 AS (SELECT 1 AS Number FROM Seq1 x, Seq1 y ),

       Seq3 AS (SELECT 1 AS Number FROM Seq2 x, Seq2 y),

       Seq4 AS (SELECT 1 AS Number FROM Seq3 x, Seq3 y),

       cteSequence AS (SELECT ROW_NUMBER()

                       OVER(ORDER BY Number) AS Sequence FROM Seq4)

SELECT * FROM cteSequence