I would feel much safer about it if he put the results of your qryAllRecords into a new table before deleting. But maybe that's just because I'm paranoid about the word delete. At 08:35 AM 8/2/00 +0200, you wrote: >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. ------------------------------------------------------------------------------ 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.
