[font="Verdana"]It seems that you are trying to delete duplicate records. What you have to do is to write a query in SQL Server 2K to return the duplicate records using HAVING clause and then delete those records.
Let us know on this,
Mahesh[/font]
MH-09-AM-8694