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;