USP_MKTSPONSORSHIPMAILINGTEMPLATE_DELETEPROMPT
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @PROMPTRESOURCEKEY | nvarchar(100) | INOUT | |
| @QUEUEPROCESSCOUNTEXCLUDINGFIRSTTEXT | nvarchar(10) | INOUT | |
| @FIRSTQUEUEPROCESSNAME | nvarchar(255) | INOUT |
Definition
Copy
create procedure dbo.[USP_MKTSPONSORSHIPMAILINGTEMPLATE_DELETEPROMPT]
(
@ID uniqueidentifier,
@PROMPTRESOURCEKEY nvarchar(100) output,
@QUEUEPROCESSCOUNTEXCLUDINGFIRSTTEXT nvarchar(10) output,
@FIRSTQUEUEPROCESSNAME nvarchar(255) output
)
as
set nocount on;
declare @QUEUEPROCESSCOUNT int = 0;
declare @TEMPLATEID uniqueidentifier = @ID;
/* sponsorship mailing process */
select @ID = [ID]
from dbo.[MKTSPONSORSHIPMAILINGPROCESS]
where [SPONSORSHIPMAILINGTEMPLATEID] = @TEMPLATEID;
exec dbo.[USP_QUEUEPROCESS_GETBUSINESSPROCESSDELETEPROMPTINFO]
@PARAMETERSETID = @ID,
@BUSINESSPROCESSID = 'b043b938-9cbe-4c3d-81e3-e3f59e0e56dc',
@PROMPTRESOURCEKEY = @PROMPTRESOURCEKEY output,
@FIRSTQUEUEPROCESSNAME = @FIRSTQUEUEPROCESSNAME output,
@QUEUEPROCESSCOUNTEXCLUDINGFIRSTTEXT = @QUEUEPROCESSCOUNTEXCLUDINGFIRSTTEXT output;
return 0;