UFN_CONSTITUENTMERGEPROCESS_GETSOURCETABLEDESC

Returns a user-friendly description of the constituent merge process record source given the table name.

Return

Return Type
nvarchar(200)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_CONSTITUENTMERGEPROCESS_GETSOURCETABLEDESC(@ID uniqueidentifier)
            returns nvarchar(200)
            with execute as caller
            as
            begin
                declare @DESC nvarchar(200);

                select 
                    @DESC = FRIENDLYNAME
                from
                    dbo.DUPLICATECONSTITUENTSEARCHRESULTSTABLE
                where
                    ID = @ID

                return @DESC;                        
            end