Here is some more T-SQL fun: number generator
I found this code in comments of this blog post and it is so cools so I decided to save it here for reference:
-- use number generation
WITH Numbers3( n ) AS ( SELECT 1 UNION SELECT 0 ),
Numbers2( n ) AS ( SELECT 1 FROM Numbers3 n1 CROSS JOIN Numbers3 n2 ),
Numbers1( n ) AS ( SELECT 1 FROM Numbers2 n1 CROSS JOIN Numbers2 n2 ),
Numbers0( n ) AS ( SELECT 1 FROM Numbers1 n1 CROSS JOIN Numbers1 n2 ),
NumbersBase ( n ) AS ( SELECT 1 FROM Numbers0 n1 CROSS JOIN Numbers0 n2 ),
Numbers ( Number ) AS
(
SELECT n
FROM ( SELECT ROW_NUMBER() OVER (ORDER BY n)
FROM NumbersBase ) D ( n )
WHERE n <= 50
)
SELECT * FROM Numbers