I just created a whole slew of calendar tables so this is something that's going in my briefcase here.

FYL - My calendar tables are wide but still fit on a page. They also have StartDt and EndDt with the EndDt being the very, very, very end of the day in milliseconds because that's how date times work here. The future queries will be easier and faster since that date bracket is already calculated. They also include breakouts of the date values both in numeric and text values, again for ease of getting the info out of the table.

I will certainly be pointing the reporting people here for info on how best to use the tables. Thanks for the clear examples!