USP_RECORDOPERATION_MEMBERMARKASPRIMARYPROMPT

Provides the prompt for the "Member: Mark as primary member" record operation.

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN Represents information to be displayed in the record operation prompt.
@NAME nvarchar(700) INOUT

Definition

Copy


                    CREATE procedure dbo.USP_RECORDOPERATION_MEMBERMARKASPRIMARYPROMPT
                    (
                        @ID uniqueidentifier,
                        @NAME nvarchar(700) output
                    )
                    as
                        set nocount on;

                        select @NAME = NF.NAME
                        from dbo.MEMBER M
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(M.CONSTITUENTID) NF
                        where M.ID = @ID

                        return 0;