Re: SQL problem enclosed. SELECTing moving window of values...

>Is the following somewhere near what you wish for?
>
>select x.m1, x.m2, count(1) as cum_sum from (select distinc
>t monthname(a.changedate) as m1, month(a.changedate) as m2, b.* from wostatus a
>, wostatus b where a.status = b.status and a.status = 'INPRG' and a.changedate
>>= b.changedate and a.changedate <= '3/1/2000' and b.changedate <= '3/1/2000')
>as x group by x.m1, x.m2 order by x.m2
>
>M1 M2 CUM_SUM
>-------- ------------ ----------- -----------
>januari 1 2
>februari 2 3
>mars 3 4
>
>3 record(s) selected.

You are absolutely correct, a cumulative sum is exactly the idea I wished to express. I'll try this out and see how she runs. Thank you for the SQL help, in advance.

-Remo Received on Thu Nov 08 2001 - 19:04:44 CET