General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
If you don't mind using a third party product... We use Merge-Purge by Arc Tangent. (805)965-7277. It is pretty good at catching the "almost identical" records, and is fast. Some of its options include the ability to display matching records on screen or report, and the ability to pick which records to keep and which to mark for deletion.
>I inherited a project from someone who wrote a long convoluted program to look for duplicates in a table. I'm wondering if it could be done easier using SQL.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only