The link below has a number of different examples. My own is, of course, the very best.:P

Creating a Formatted Calendar

There are several methods is this link that will return a result set with a formatted calendar.

Calender In Sql Server:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44865