Re: tricky time interval billing problem

2005-12-06 Thread pruebauno
> First of all, you need to use ordering to ensure that the database gives > you the most convenient order for processing, as this will make your > computations much easier. So I'd suggest sorting by clientNumber, > ServiceNumber, Begindate and Enddate. That way you can consider each > service sepa

Re: tricky time interval billing problem

2005-12-05 Thread Steve Holden
[EMAIL PROTECTED] wrote: > I am currently working on a tricky problem at work. I googled around a > bit, but "time intervals" did not come up with anything useful. > Although I have some rough idea of how I could solve it, I still would > value some input. > > I have information of (It has only co