Correct Cetin, that's exactly what I'm going to do in this momment with all the solutions I got here.
>Esparta,
>Many things are possible with a single query however think of performance too. Check with large tables too.
>>Thanks Cetin, and yes, it could be better, I was wondering if this is possible with a single query, I'll do the test to see what's the better approach. Thanks again!
>>
>>
>>>Esparta,
>>>I think dividing it would be better. Roughly:
>>>Select iAgentId, Month(dDate) As Month, Year(dDate) As Year, Sum(yAmount) As YTot ;
> FROM cMovs ;
> GROUP By 1,2,3 ;
> into Cursor crsSums ;
> nofilter
>
>Update cAgent ;
> SET yMonth = t2.YTot ;
> FROM crsSums t2 ;
> WHERE t2.iAgentId = cAgent.iid ;
> AND cAgent.nMonth = 1 And cAgent.nYear=2005 ;
> And t2.Month = cAgent.nMonth ;
> AND t2.Year = cAgent.nYear
>