I have two SQL databases. One is for Candidates and one is our Main database. We have a sp that transfers a Candidate into our Main database once we make contact with them and then deletes them from the Candidate database. Problem is, our sp to delete from the Candidate database is not working - so we have duplicate entries in both databases.
I need a query so I can look for duplicates in both databases.
Database 1 - CandSource Table - Contact1
Database 2 - Goldmine Table - Contact1
output to delimited file.
I know this is easy for a SQL god...but I am not one...
Thank you thank you.