USP_MKTSEGMENTWHITEMAIL_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_MKTSEGMENTWHITEMAIL_DELETEPROMPT]
(
@ID uniqueidentifier,
@PROMPTRESOURCEKEY nvarchar(100) output,
@QUEUEPROCESSCOUNTEXCLUDINGFIRSTTEXT nvarchar(10) output,
@FIRSTQUEUEPROCESSNAME nvarchar(255) output
)
as
set nocount on;
/* get the parameter set id from the white mail id */
select @ID = [ID]
from dbo.[MKTSEGMENTWHITEMAILREFRESHPROCESS]
where [SEGMENTID] = @ID;
exec dbo.[USP_QUEUEPROCESS_GETBUSINESSPROCESSDELETEPROMPTINFO]
@PARAMETERSETID = @ID,
@BUSINESSPROCESSID = '074E87E1-2417-453E-9C70-1B7DD04EAA1D',
@PROMPTRESOURCEKEY = @PROMPTRESOURCEKEY output,
@FIRSTQUEUEPROCESSNAME = @FIRSTQUEUEPROCESSNAME output,
@QUEUEPROCESSCOUNTEXCLUDINGFIRSTTEXT = @QUEUEPROCESSCOUNTEXCLUDINGFIRSTTEXT output;
return 0;