You don't have to have a Tally table made in your database. Using common table expressions, you can generate them on the fly. Here is such using the example code...

I'm trying to remember. Do you have to turn back on DBCC TRACEON each time you restart the instance?