USP_RECORDOPERATION_PLEDGEREMINDERPROCESSSTATUS_DELETEPROMPT

Provides the prompt for the "Pledge Reminder Process Status: 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_PLEDGEREMINDERPROCESSSTATUS_DELETEPROMPT
                            (
                                @ID uniqueidentifier,
                                @MESSAGE nvarchar(150) output
                            )
                            as
                                set nocount on;

                                if exists (select ID from dbo.PLEDGEREMINDERSENT where PLEDGEREMINDERPROCESSSTATUSID = @ID and 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;