I've done the same thing using the more generic Tally or Numbers table.

Here's a good article by Jeff about it.

http://www.sqlservercentral.com/articles/T-SQL/62867/