>>Route Class SType Family PrevPassngers PrevMult PrevNumTrips CurrPassengers CurrMult CurrNumTrips >>0588 D G 386 1.75 676.79 >>0588 D G 147 1.00 147.00 >>0588 D G 194 1.00 194.00 >>0588 D G 313 1.00 213.00 >>0011 C B 33 1.75 57.86 >>0011 C B 1 1.00 1.00 >>0016 C E 675 1.75 1183.51 >>0016 C E 3 1.00 3.00 >>0016 C E 17 1.00 17.00 >>0016 C E 10 1.00 10.00 >>... >> >>and need to condense/combine them into 1 rec for each Route/ClassStype/Family combo, i.e. >> >>Route Class SType Family PrevPassngers PrevMult PrevNumTrips CurrPassengers CurrMult CurrNumTrips >>0588 D G 386 1.75 676.79 554 1.00 554.00 >>0011 C B 33 1.75 57.86 1 1.00 1.00 >>0016 C E 675 1.75 1183.51 30 1.00 30.00 >>>>Is there a quick SQLish way of doing this without having to loop and append and accumulate and all that?
>SELECT Route, Class, SType, Family,; > SUM(PrevPassngers) AS PrevPassngers,; > SUM(PrevMult) AS PrevMult,; > SUM(PrevNumTrips) AS PrevNumTrips,; > SUM(CurrPassengers)AS CurrPassengers,; > MAX(CurrMult) AS CurrMult,; > SUM(CurrNumTrips) AS CurrNumTrips; >FROM MyTable; >GROUP BY Route, Class, SType, Family; >INTO CURSOR crsTest >BROSE NORMAL >