Folks, the GetNums function that Matjaz reference is Itzek Ben-Gan's cascading Cross Join code wrapped in a function. If you decide to use that instead of some other method, make sure you use the code that has "TOP" in it for the very reasons that Itzek mentions and the fact that I've also confirmed it's a bit faster than his previous rendition. Itsek's article can be found at the following URL:
http://www.sqlmag.com/article/sql-server/virtual-auxiliary-table-of-numbers
--Jeff Moden
Change is inevitable... Change for the better is not.