>>Do you want me to torture you? :)
>
>:o)))))))))))))))))
>
>>I give you 5 more minutes for figuring this out. BTW, I should have figured it out myself right away, but only after I run Profiler by your advice it became obvious for me.
>
>
>Why not put everything in one query?, why you need to split it to 3 different batches?
>
>>
>>Funny thing that I spent more than 1h. on this problem - now, it seems I have to go back as I don't see an alternative.

Because I need to get both cursors back and make both updatable. May be it will be also quick without using temp table (with subquery), but since that's how it was originally coded, I'll keep it and for this case embed parameters as it was before. We're using special function VFP2SQL, so it's almost safe.

BTW, there are 2 batches, not 3.