Maybe: Step 1: SELECT DISTINCT ... (all colums), name it qryAllRecords Step 2: DELETE FROM <yourtable>, now you're table is empty Step 3: LOOP over qryAllRecords and insert them into the database. Make sure you have a backup and use CFTRANSACTION! Best Regards, Johan Coens -----Original Message----- From: aslam bajaria [mailto:[EMAIL PROTECTED]] Sent: woensdag 2 augustus 2000 6:30 To: [EMAIL PROTECTED] Subject: Help! 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. ------------------------------------------------------------------------------ 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.
