USP_MKTSEGMENTGROUP_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_MKTSEGMENTGROUP_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 group id */
select @ID = [ID]
from dbo.[MKTSEGMENTGROUPREFRESHPROCESS]
where [SEGMENTGROUPID] = @ID;
exec dbo.[USP_QUEUEPROCESS_GETBUSINESSPROCESSDELETEPROMPTINFO]
@PARAMETERSETID = @ID,
@BUSINESSPROCESSID = '6D70A1EA-38B7-419F-963E-3E183753223D',
@PROMPTRESOURCEKEY = @PROMPTRESOURCEKEY output,
@FIRSTQUEUEPROCESSNAME = @FIRSTQUEUEPROCESSNAME output,
@QUEUEPROCESSCOUNTEXCLUDINGFIRSTTEXT = @QUEUEPROCESSCOUNTEXCLUDINGFIRSTTEXT output;
return 0;