Ken (and also Jay),

I understand that my offering is not applicable in all cases and that some are not concerned about performance. I am just illustrating alternatives for shops...

This is a great solution for the sake of its simplicity. However, it is not workable for environments with large transactional loads on the source and destination tables.

I work...

What ever happened to simply grouping by the primary key with a count > 1? Wouldn't that find dupes just as well? It seems like overkill to run...