USP_RECORDOPERATION_PLEDGEREMINDERPROCESS_DELETEPROMPT
Provides the prompt for the "Pledge Reminder Process: Delete" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Represents information to be displayed in the record operation prompt. |
| @MESSAGE | nvarchar(150) | INOUT |
Definition
Copy
CREATE procedure dbo.USP_RECORDOPERATION_PLEDGEREMINDERPROCESS_DELETEPROMPT
(
@ID uniqueidentifier,
@MESSAGE nvarchar(150) output
)
as
set nocount on;
if exists (select PRS.ID from dbo.PLEDGEREMINDERSENT PRS
inner join dbo.PLEDGEREMINDERPROCESSSTATUS STATUS on PRS.PLEDGEREMINDERPROCESSSTATUSID = STATUS.ID
where STATUS.PARAMETERSETID = @ID and PRS.SENTDATE is null)
select @MESSAGE = 'Reminders in this process have not been marked sent and results will be cleared.'
else
select @MESSAGE = null;
return 0;