I have a table with a primary key that has three columns. I am taking data from an outside source and need to insert the data into the table. Data in the record set could be updated later in the dataset. If it is not there I want to do an insert, if the primary key is already in the table I would like to update the remaining values. Is there a simple update to use that if the record is not there it adds it, I would not like to try an insert and then update if a pk error is thrown? To much error overhead in processing. If any could lend an insight that would be great.
