SDU Tools 135 Table of Numbers version 2 in SQL Server T SQL
SDU Tools are free tools and example T-SQL code for SQL Server developers and DBAs. The TableOfNumbers function does just what the name says. You give it a starting value and a number of numbers required, and it returns of table of those numbers. (It is different to our earlier version of the same function and has less restrictions).
To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com