>>>>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
If it's not broken, fix it until it is.
My Blog