Thanks for your reply Neeraj and my apologies for the delayed response due to the Weekend.

I tried your solution but unfortunately it gave me some errors.

I have attached the sample data from the source table and also the details of both the tables. The structure of both the tables are same except that the source table does not have a primary key and the destination table has a defined primary key combination.

I have mentioned required details in the attached sheet with the name "Duplicate ROs insertion issue".

Please let me know if you need more info.

Thank You in advance.

Thanks and Regards,

Prasune Verma

+91 9503194429