USP_RECORDOPERATION_TEAMFUNDRAISINGTEAMMEMBER_DELETE_PROMPT
Provides the prompt for the "Team Fundraising Team Member: Delete" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Represents information to be displayed in the record operation prompt. |
| @TEAMFUNDRAISERNAME | nvarchar(154) | INOUT | |
| @TEAMNAME | nvarchar(100) | INOUT |
Definition
Copy
CREATE procedure dbo.USP_RECORDOPERATION_TEAMFUNDRAISINGTEAMMEMBER_DELETE_PROMPT
(
@ID uniqueidentifier,
@TEAMFUNDRAISERNAME nvarchar(154) output,
@TEAMNAME nvarchar(100) output
)
as
set nocount on;
select
@TEAMFUNDRAISERNAME = dbo.UFN_CONSTITUENT_BUILDNAME(TEAMFUNDRAISER.CONSTITUENTID),
@TEAMNAME = coalesce(TEAMFUNDRAISINGTEAM.NAME, APPEAL.NAME)
from
dbo.TEAMFUNDRAISINGTEAMMEMBER
inner join dbo.TEAMFUNDRAISER on TEAMFUNDRAISINGTEAMMEMBER.TEAMFUNDRAISERID = TEAMFUNDRAISER.ID
inner join dbo.APPEAL on TEAMFUNDRAISER.APPEALID = APPEAL.ID
left join dbo.TEAMFUNDRAISINGTEAM on TEAMFUNDRAISINGTEAMMEMBER.TEAMFUNDRAISINGTEAMID = TEAMFUNDRAISINGTEAM.ID
where
TEAMFUNDRAISINGTEAMMEMBER.ID = @ID;
return 0;