Eliminate double entries from the #Duplicates temporary table (which needs to be created by the caller).

This procedure is called by usp_ag_showdup. Because of the nature of duplicates, if record A is a duplicate of record B, the #Duplicates table will have one record reporting that A is a duplicate of B, plus one record reporting that B is a duplicate of A. This procedure removes the (somewhat reduntant) second record.

Note that this is only true when A and B are of the same type. If A and B are of different types (e.g. Contact and Account) only the record where A is the base entity is ever inserted in #Duplicates.


There is no return value.


  • Because this procedure accesses low level objects, it must be executed by a system administrator. A normal CRM user will not be able to execute it.

Last edited Jul 31, 2011 at 5:57 PM by gemina, version 2


No comments yet.