thank you so much, One approach it works, it is very help

i want to give this soluation more more........than 3 stars

have anice time

>>thanks again
>>Is Name + Month combination unique? yes
>>And each Name repeats for each month?yes
>
>One approach - not good performance
>

>   select T.Nam, T.ID1, (select sum(Y2010) as YTD from NewTest T1 where T1.Nam = T.Name and T1.ID1 <= T.ID1) as YTD from 
>   NewTest T into cursor crsYTD
>

>Second approach I already wrote in my other message - use scan and intermediate cursor.