Very good points. I was just going to start looking up similar solutions in Itzik's books when I saw your post. I figured there was a way to bring a table of numbers into this somehow.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning