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 ...