Following script is a quick and easy way to generate 10000 numbers . You can change the number to generate howmany ever numbers you want.
2013-09-17 (first published: 2013-09-06)
1,444 reads
Generate N numbers
WITH Number AS (SELECT 1 AS n UNION ALL SELECT n + 1 FROM Number WHERE n < 10000) SELECT n FROM Number OPTION ( MAXRECURSION 10000 );
Related content
Exploring Recursive CTEs by Example
Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons.
2014-07-25 (first published: 2012-07-17)
26,960 reads
Hidden RBAR: Counting with Recursive CTE's
"Counting" is essential to many high performance code techniques. SQL Server MVP, Jeff Moden, shows us how to make sure that we're "Counting" and not "Crippling" our trick-code.
2011-08-08
22,223 reads
Common table expressions and circular references
Finding circular references that are stopping your CTE from working.
2013-09-02 (first published: 2011-01-31)
19,504 reads
Flexable Rate Recursion
A Recursion function that was used to apply a Rate percentage to a base amount for the reqested number of times.
2010-10-28 (first published: 2010-10-13)
565 reads