Delete until unique..?

[kenjoswe]

Hi all,

I have a script that looks for duplicates and deletes them:
================================
select Cnt=min(Cnt)
into #temp
from Tbl1
group by BusinessPartnerNumber
having count(BusinessPartnerNumber)>1

DELETE Tbl1
FROM Tbl1 k INNER JOIN #temp t
ON k.cnt = t.cnt
=================================

I would like to repeate this until there is no more duplicates.

How can I do this?

 

[dbomrrsm]

take a look at:

http://www.15seconds.com/issue/011009.htm

good article about duplicates - you have to be careful as what you are doing above may end up deleting all records where there was more than one occurence but infact you actually want to leave one record.

[blue]DBomrrsm[/blue]