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,442 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,761 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
21,777 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,295 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)
563 reads