Some additional information that should everyone understand where I'm at with this process.

I have a contact table that I've removed multiple duplicates from already. These duplicates are in the...

Rules are that the lowest Source number should come first, if those tie than take the lowest Contact_pk.

amurjani (7/16/2015)

---

Consider this idea (if not already considered). It is my experience in dealing with such data:

In these situations, the data quality plays a major role. First objective is to...

SSCertifiable,

I've been playing with the cross apply and trying to get it to work with a few other requirements. Each business group I should easily be able to tell...

ChrisM@Work (6/9/2015)

---

@Jeff, please can you amend your sample data set so that it contains each of the conditions you describe? Thanks. Then run this and have a look at the...

Jacob Wilkins (6/8/2015)

---

It seems the second rule listed serves no purpose, if I understand this correctly.

I might be misunderstanding something here, but I figured I'd lay that out to see...

That worked, I knew there had to be a better way and that is it.

ah, understood, but the business key duplicates are almost never sequential, so a range would not work.

The solution with the min and max would work if there were only duplicates, but Businesses have been known to be duplicated 100s of times due to previous incorrectly coded...

In the PossibleDuplicateBusiness table I want MatchRank of 1,2,3,etc but only include the MatchRank of 1 if they are also in a duplicate group.

Both suggestions seem to bring back all...

Eirikur Eiriksson (8/27/2014)

---

Hi and welcome to the forum, complements on the fine DDL and sample data!

Not too clear on what you are after but please bear with me as I'm...

pietlinden (8/27/2014)

---

Nice job posting DDL and sample data! How do you determine which rows are/are not the Current Edition? Once we have that, the rest of this should...

Me,

I'm just happy to have better options than before! Thanks for all the help!

SSCommitted,

Thanks for the quick solution! I've been able to take what you gave me and tie it into the limit to the Farm.CodeToMatchTo that I'm currently searching on. ...

Hi all, I've added some code below. I had everything working until I found a case that returns more than complete data. I have to let the caller...