>>>Edward,
>>>
>>>Thank you for your suggestion. But I'm afraid that this way might be even more time consuming, because each insert into the cursor will have to take the indexes into account. Would you not agree?
>>>
>>>Thanks again,
>>>
>>>Marc
>>
>>I disagree because you will need in one INSERT only which might be slower by few milliseconds (I believe you use Rushmore).
>
>Is there a way to insert more than record at a time in the cursor? Or is there something else that I am missing?
>
>Thanks (alse for you patience :)
>
>Marc
You can SELECT ... INTO array ... and then INSERT INTO ... FROM array
Edward Pikman
Independent Consultant