I confirm Adi. A Tally/Numbers table is a great helper for many things. It requires about 150kb disk usage and the profit is really huge.

Have look to this article just to see some of the gains:

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