Re: Impossible SQL query?

What you'll end up with is something like this:

B1     E3
B2     E5
B4     E6
B8     E7
B9     E10

where E7 gets incorrectly paired with B8. We actually want to discard E7 because there aren't enough begin points before it. There would need to be some logic that checks the dates so end points come after begin points. But then you would also need to change the row numbers for the following rows so they match up correctly. Received on Wed Oct 05 2005 - 10:35:10 CDT