Some SQL gurus might disagree, and I wouldn't argue the point heavily, especially if you didn't plan on reading all the resulting rows (though why?).

This has been driving me crazy. Can anyone help me understand how I can dynamically create a sort of calendar view for a promotional schedule? I can't seem to get anything to work My table (tbl ...

PowerPivot with SQL Server 2008 R2 One of the prime-time features of Microsoft SQL Server 2008 R2 is provided by the “Project Gemini” technology known as PowerPivot for “Self Service BI”.