Can you help me with my query to find duplicate records?
Query pasted in PM
Query pasted in PM
We will have to do this in a premier support ticket. I'm not confident I can do it remotely without being able to test my results while connected to your database.
I determined it was easiest to export to excel since 1. My column headings did not match, 2. Excel has a quick and easy remove duplicates.
After removing, it is easy to import to a temp table with the same structure of the table that will be the final destination.
The final destination table and the temp table should have a UNIQUE index defined to confirm we have -0- duplicates.
Then import from the temp table to the final table (column headings match now because of the import took care of that).
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.