Scotty wrote:
>Jan Hidders wrote:
>>Scotty wrote:
>>>I'm curious to ask whether you think the theory behind my query works
>>>or not, given test data that reasonable constraints would allow.
>>
>>Run the test and you will know. If it finds the right bookings your theory
>>is correct, if it doesn't it's false.
>
>Then it's correct.
Yes, it is. Somehow I seemed to have swapped the '<' for '>' when I first
read your query. My apologies for the misunderstanding. Btw., you can still
simplify your query a litte: you can remove tha -todate(...) everywhere and
the first and second equations are redundant.
Received on Mon Nov 11 2002 - 04:46:59 CST
