http://cs.vbcity.com/blogs/mike-mcintyre/archive/2008/12/31/welcome-2009-create-a-calendar-with-microsoft-transact-sql-how-to-iterate-days-in-a-series.aspxOne puzzle SQL developers face from time to time is creating a calendar containing a series of days. Below is some SQL code that will create an in-memory calendar for every day from a begin date to an end date. By adding more columns to the #CalendarenCommunityServer 2008 (Build: 30417.1769)