Posted by Chung Leong on 10/24/06 17:38

Rik napisal(a):
> My solution was purely to give him back the information he wants (he not
> only wants to reject invalids, update already existing, and insert new, but
> he wants to know which ones they are).
>
> The actual updating can still be done with the previous simple replace
> into, avoiding race condition.

I'm afraid the OP is still thinking in terms of loading up an array
with existing records to see which not to insert. Sometimes you can get
away with having a race, but inserting hundreds of records is a long
operation. There is a reasonable chance that a second select could come
along and beat it.

[Back to original message]