Share via

Duplicate rows - Ignore

M, Murugeswari (Cognizant) 456 Reputation points
2022-02-25T16:36:22.457+00:00

Hi,

I have 6 columns. Lets consider the column names as A,B,C,D,E,F. If all the first four column (A,B,C,D) values are same, then we consider it as duplicates. We need to load the data only if atleast any of the first four column values does not have the same value. Is there any way

For example, the below is consider as duplicate and I want to avoid that

177926-image.png

Thanks

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,678 questions
Accepted answer
  1. Nasreen Akter 10,806 Reputation points
    2022-02-28T20:24:43.73+00:00

    Hi @Anonymous , you can create composite key with this 4 i.e., A,B,C,D columns. Thanks!

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.