troubleshooting Question

duplicate column entries

Avatar of navajo26354
navajo26354Flag for United States of America asked on
Microsoft SQL Server
4 Comments1 Solution424 ViewsLast Modified:
I have a two column table.  In column1 I have duplicate userID entries.  In column2 the values are distinct with the exception of one or two.  I want to get rid of all duplicate values in column1 and then make column1 a primary key.  Before I get rid of them I'd like to identify all of the duplicate column1 values and place each record with a duplicate column1 value into a new temporary holding table.  Can anyone provide me with a script to do this?  All the scripts I have found assume both column1 and column2 have duplicates (a duplicate record) but this is mostly not the case for me.  I'm only concerned with the duplicates in column1.
Sharath S
Data Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros