I get an XML that contains records which I need to insert into a table ABC.
The challenge is some of the records within the xml are already present in the table ABC ( thats why I am getting unique key constraint error). So I have to update those records instead of insert.
How can I differentiate those records from new records and create a separate xml and update into table ABC??