|TSQL ->||Create tally table ("Numbers" table) in TSQL|
Tally table ("Numbers" table) is extremly usefull for a number of SQL queries
solutions. Following script creates table that will store 100000 sequential numbers.
More about TSQL technuque for creating tally table:
Tally Table - Number Table. Script on databasechallenges.com
Create function that returns tally table of a given size
More about uses of tally (numbers) table:
Split character string to words using tally table