Is there a reason why this would be better than selecting rows from a Calendar table?

Have a look at:

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html