Hi I have a flat file of 400,000 records.
I have an existing table that matches the flat file. This wil be the second time I read the data in. The first time the table was empty. This time the table is full and about 10% of the fields will be new, 10% will need to be update. How can I read through the flat file and decide if the key already exists. If it does I want to update the table if it does not I want to insert the data into the table. I do not know ahead of time which frows will have changes data so if I need to do every record that exists and update it thats ok.
This is a once every quarter update speed is not an issue.