USP_MKTSEGMENTATION_TOGGLECALCULATIONMODEPROMPT
Provides the prompt for the "Mailing: Toggle Calculation Mode" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Represents information to be displayed in the record operation prompt. |
| @PROMPT | nvarchar(1024) | INOUT |
Definition
Copy
create procedure dbo.[USP_MKTSEGMENTATION_TOGGLECALCULATIONMODEPROMPT]
(
@ID uniqueidentifier,
@PROMPT nvarchar(1024) = null output
)
as
set nocount on;
if (select [MANUALCALCULATIONMODE] from dbo.[MKTSEGMENTATION] where [ID] = @ID) = 1
set @PROMPT = 'Are you sure you want to turn on auto calculation mode?' + char(13) +
'This process may take a few minutes to refresh.';
return 0;