Forum Discussion
prathap3567
Mar 24, 2021Copper Contributor
How to avoid duplicates in XML while inserting into SQL Table
Note: this is a sample code and scenario. I will not be using distinct while using select statement. I'm trying to upload Itemcodes into an empty table for the first time using XML. below is ...
RickG2
Mar 24, 2021Brass Contributor
prathap3567 Upload the data to a buffer table. Do any needed data cleansing and validation, and then transfer the data to the final destination. If genuine duplicates are possible you can use DISTINCT when pulling the data from the buffer table. Clear the buffer table before each use.