Re: complex? SQL time series problem

Mark.Powell_at_eds.com says...
> Geoff, wouldn't that be just group by c_set, stts, (e_date - s_date)
> with a matching select list plus count(*)?

Can't see it. More simply, I need to eventually plot this against a date dimension, so I need:

 s_date       e_date     c_set  c_id  stts
01-jan-2000  15-mar-2000  a2     125   A
17-jul-2000  sysdate      a2     125   A
14-may-2000  sysdate      a2     158   A

to become: 
c-set   stts     s_date      e_date       count(c_id)
a2       A     01-jan-2000  15-mar-2000      1
a2       A     14-may-2000  16-jul-2000      1
a2       A     17-jul-2000  sysdate          2

Need to derive an e_date value of 16-jul-2000 amongst other things.

Geoff M Received on Mon Feb 14 2005 - 17:51:03 CST