Duplicate records, how to process (1 Viewer)

[Jallan!]

I have records in a file. New records need to be added and I do this with an update. What is the best way to process a set of new records to be added (10,000) and not process records that already exist in the target table?

With an SQL does not exist?

Looking for best way to do this and not melt the processor when processing records that already exist in the table.

 

[Ranman256]

make an update query to mark the recs as EXISTS, in the incoming table.
then make your append query add recs by filtering out these existing recs.