There is a feedback entry for SQL 2008 at
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3569354&SiteID=1&mode=1
by MVP Erland Sommarskog that appears to be lobbying for a "Table of Numbers" aka "Tally Table" to come as a built in feature of SQL Server. If you are interested in this kind of feature pay a visit to the listed feedback and give it a review.
Kent