Hello All, There is a very seriuous problem I am facing. Please help. The problem is as follows: Somehow I have created duplicate records in SQL Server 7.0 table. I have to remove the duplicate the records. It all happened because there is no primary key when the record was created. If it were a few records, I could have manually deleted them. Now the records are in thousands. Can someone suggest me a code that would check for duplicate values in a table and delete them. Please help. A.B. __________________________________________________ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/ ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
