USP_SIMPLEDATALIST_DUPLICATECONSTITUENTSEARCHRESULTTABLE

Returns a list of all the tables in the database that contain duplicate search results.

Definition

Copy


                create procedure dbo.USP_SIMPLEDATALIST_DUPLICATECONSTITUENTSEARCHRESULTTABLE
                as
                    set nocount on;

                    select 
                        ID as VALUE,
                        FRIENDLYNAME as LABEL
                    from
                        dbo.DUPLICATECONSTITUENTSEARCHRESULTSTABLE
                    order by FRIENDLYNAME;