Edit: I think your solution is good ... let me do some more tests ... if so, that would be awesome!

Edit-Edit: Your solution is pretty freakin' awesome! Yours is...

Here's what I was able to come up with so far ... do you guys think there is a way to simplify this?

declare @event table (id int identity(1,1), beginDate datetime,...

The events table will specify the time, the dateRange values will not.

So for example, I will have, 2009-02-01 00:00:00 thru 2009-02-28 00:00:00

While an event can start at like, "2009-02-01 8:30:00"...

Great post- it looks like I will be able to utilize/modify parts of this code to work with my business needs ... the report I'm creating is tough!

See if you...