Okay, I'm still confused. The second table sounds like a results table, but then why did you ask for a result in a different format (in your first query)? If it isn't a results table, then what is it?

Secondly, I don't believe you answered my question. If 2 date ranges overlap in the first table, what is the rule for which range wins for which dates? What if there are 3 overlapping ranges?

Please provide as much detail as possible.

- Chris