Hi ssc37.

Do you have all of your match conditions defined? If so, what are they? It would be helpful to know what you are using to consider records similar.

I loaded your data into a temporary table and queried three columns as follows.

select mm,m,k , COUNT(*) as RecCount
from [dbo].[testing_data]
group by mm,m,k
having COUNT(*) > 1
[download]

I know this isn't the Perl solution you are after, but does this help?