• [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