>>>>>Would this work:
>>>>>
>>>>>update myTable set myField = mycursor.myField from myTable inner join myCursor on
>>>>
>>>>Yes it'll work assuming that you provide correct JOIN conditions. :)
>>>
>>>Yes, it did <g> But it was a bit slow. Perhaps adding an index to temp cursor will help?
>>
>>How long does it take? How many records do you have in the cursor?
>
>~20+ sec. 42K

UPDATE-SQL locks/unlocks each record. Try to FLOCK the table and see how much it will speed the update. You can also try to create an index on the cursor but I wouldn't expect it to speed up update much.