USP_RECORDOPERATION_PROSPECTRESEARCHTEMPLATE_DELETEPROMPT

Provides the prompt for the "Prospect Research Report Template: 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
@PROMPTRESOURCEKEY	nvarchar(150)	INOUT

Definition

Copy



                            CREATE procedure dbo.USP_RECORDOPERATION_PROSPECTRESEARCHTEMPLATE_DELETEPROMPT
                            (
                                @ID uniqueidentifier,
                                @MESSAGE nvarchar(150) output, --Deprecated

                                @PROMPTRESOURCEKEY nvarchar(150) output
                            )
                            as
                                set nocount on;

                                if exists (select ID from dbo.PROSPECTRESEARCHTEMPLATEDEFAULT 
                                           where PROSPECTRESEARCHTEMPLATEID = @ID)
                                  set @PROMPTRESOURCEKEY = 'ProspectResearchDeleteWithOwners'
                                else
                                  set @PROMPTRESOURCEKEY = 'ProspectResearchDeleteNoOwners'

                                return 0;