SQL Server: BulkMerge with Uniques

[mhesham93]

Is it possible to perform a BulkMerge with existing data and avoid merging duplicate records? if so can you please post a sample?

Thanks

[mikependon]

Hi @mhesham93 , no, it is not possible, it is either of "inserting a new record" or "updating an existing record" based on the qualifier.

[mhesham93]

Thanks Michael, so if I’m importing data from a file and then I re-import the file to update the records do I use update instead of merge to avoid this problem? Thank you, Mohamed Said

…

________________________________ From: Michael Camara Pendon ***@***.***> Sent: Thursday, April 22, 2021 4:08:40 PM To: mikependon/RepoDB ***@***.***> Cc: mhesham93 ***@***.***>; Mention ***@***.***> Subject: Re: [mikependon/RepoDB] SQL Server: BulkMerge with Uniques (#816) Hi @mhesham93<https://github.com/mhesham93> , no, it is not possible, it is either of "inserting a new record" or "updating an existing record" based on the qualifier. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub<#816 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ACK2O3DXMFHTJQMWKSATX73TKB64RANCNFSM43LVZBKQ>.