>>GroupID Month Value YTD (values we want to have) >>1 1 10 10 >>2 1 15 15 >>1 2 20 30 >>2 2 5 20 >>>>
>>select T1.GroupID, (select sum(Value) from myTable T2 where T2.GroupID = T1.GroupID and T2.Month <=T1.Month ) as YTD >>from myTable T1 >>>>
>>>SET DELETED ON >>>USE newtest >>>UPDATE newtest SET y2010 = T.val1 from newtest inner join hamad T on newtest.ID = T.ID WHERE id1=2 >>> >>>UPDATE newtest SET PER1= (Y2010-Y2009)/Y2009 from newtest WHERE ID1=2 >>>*brow >>> >>>*********************************************************************** >>>scan >>> >>>SET FILTER TO ID1=2 AND FLG=1 >>> SUM Y2010 TO M.D FOR id1=2 >>> >>> >>>SET FILTER TO >>> REPLACE Y2010 WITH M.D FOR NAM="TOT1" AND id1=2 >>> >>>endscan >>> >>>scan >>> >>>SET FILTER TO ID1=2 AND FLG=2 >>> SUM Y2010 TO M.D FOR id1=2 >>> >>> >>>SET FILTER TO >>> REPLACE Y2010 WITH M.D FOR NAM="TOT2" AND id1=2 >>> endscan >>> >>> >>>scan >>> >>>SET FILTER TO ID1=2 AND FLG=3 >>> SUM Y2010 TO M.D FOR id1=2 >>> >>> >>>SET FILTER TO >>> REPLACE Y2010 WITH M.D FOR NAM="TOT3" AND id1=2 >>> endscan >>>>>>
>>>>>>>Field Field Name Type Width Dec Index Collate Nulls Next Step >>>>>>> 1 ID1 Numeric 3 No >>>>>>> 2 ID Numeric 2 No >>>>>>> 3 NAM Character 10 No >>>>>>> 4 Y2009 Numeric 15 3 No >>>>>>> 5 Y2010 Numeric 15 3 No >>>>>>> 6 PER1 Numeric 15 3 No >>>>>>> 7 TY2009 Numeric 15 3 No >>>>>>> 8 TY2010 Numeric 15 3 No >>>>>>> 9 TPER Numeric 15 3 No >>>>>>> 10 FLG Numeric 2 No >>>>>>>** Total ** 108 >>>>>>>>>>>>