By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 897 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

Removing Duplicate Data Problem..!

P: n/a
En
Any ideas what to do for the best?

I have a table that records some transaction data. Each entry in the table
has an auto gen primary key / ID.

Somewhere along the way there are 1000's of duplicate transactions been
entered, however they are unique because they have different primary key /
ID.

Does anyone know the best way to remove the duplicates from the table but
leaving one copy of the transaction in the table???

I tried a simple delete find duplicate query that found all the duplicates
including the original transaction. I cant afford to delete the original
transaction though.

Any suggestions welcome.

Ian
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Take a look at this article ...

http://www.databasejournal.com/featu...le.php/3077791
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"En" <ia*@ihankinson.freeserve.co.uk> wrote ...
Any ideas what to do for the best?

I have a table that records some transaction data. Each entry in the table
has an auto gen primary key / ID.

Somewhere along the way there are 1000's of duplicate transactions been
entered, however they are unique because they have different primary key /
ID.

Does anyone know the best way to remove the duplicates from the table but
leaving one copy of the transaction in the table???

I tried a simple delete find duplicate query that found all the duplicates
including the original transaction. I cant afford to delete the original
transaction though.

Any suggestions welcome.

Ian

Nov 12 '05 #2

P: n/a
En
That looks excellent, thankyou.

Ian
"Danny J. Lesandrini" <dl*********@hotmail.com> wrote in message
news:bt************@ID-82595.news.uni-berlin.de...
Take a look at this article ...

http://www.databasejournal.com/featu...le.php/3077791
--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"En" <ia*@ihankinson.freeserve.co.uk> wrote ...
Any ideas what to do for the best?

I have a table that records some transaction data. Each entry in the table has an auto gen primary key / ID.

Somewhere along the way there are 1000's of duplicate transactions been
entered, however they are unique because they have different primary key / ID.

Does anyone know the best way to remove the duplicates from the table but leaving one copy of the transaction in the table???

I tried a simple delete find duplicate query that found all the duplicates including the original transaction. I cant afford to delete the original
transaction though.

Any suggestions welcome.

Ian


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.