hi,
Sorry the last code i send it works ,
i want to show how i get values monthly and replace ment at newtest.
i need to update just the newtest as what i ask before, thank you for code
>Sorry - it looks like you don't need to use SCAN in that code, but anyway, you lost me.
>
>Let's assume this structure
>
>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
>
>
>>hi,
>>
>>evrye values for filelds partofname is 2009 it is old values just i used to compare ,
>>
>>but every month i fill(replace) the newtest form another table have 6 values via this code
>>
>>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
>>
>>
>>
>>
>>
>>>The output above was not really helpful. Do you match records by name? In other words, for each month you have many records. How do you match each month?
>>>
>>>>>
>>>>>>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
>>>>>
>>>>>
>>>>>Ok, and also some data (copy to 'temp.txt' delimited with tab)