SQL Server 2008 Attendance Report for Every Day of a Month

Generating Two Records per Original Record: A Creative SQL Solution Using Cross Joins and Crystal Reports