USP_RECORDOPERATION_MKTREMOVEMEMBERSPROCESS_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_RECORDOPERATION_MKTREMOVEMEMBERSPROCESS_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 process id */
select @ID = [PARAMETERSETID]
from dbo.[MKTUPDATEMAILINGCOUNTSPROCESSSTATUS]
where [ID] = @ID;
exec dbo.[USP_QUEUEPROCESS_GETBUSINESSPROCESSDELETEPROMPTINFO]
@PARAMETERSETID = @ID,
@BUSINESSPROCESSID = '4cd4d8de-d0b7-4378-a7f2-23cc99a75e6d',
@PROMPTRESOURCEKEY = @PROMPTRESOURCEKEY output,
@FIRSTQUEUEPROCESSNAME = @FIRSTQUEUEPROCESSNAME output,
@QUEUEPROCESSCOUNTEXCLUDINGFIRSTTEXT = @QUEUEPROCESSCOUNTEXCLUDINGFIRSTTEXT output;
return 0;