Generate a set or sequence without loops - part 1 - SQLPerformance ...

There are 2,164 unique and 2,508 total values in SQL Server 2008 R2; in 2012 there ... you could write a slightly simpler query to generate the same sequence:.

sqlperformance.com