USP_MKTPACKAGE_PARSECONTEXTID
Parses various values out of the package add forms' context.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONTEXT | nvarchar(128) | IN | |
| @MAILINGTYPECODE | tinyint | INOUT | |
| @BASECURRENCYID | uniqueidentifier | INOUT | |
| @SITEID | uniqueidentifier | INOUT |
Definition
Copy
CREATE procedure dbo.[USP_MKTPACKAGE_PARSECONTEXTID]
(
@CONTEXT nvarchar(128),
@MAILINGTYPECODE tinyint = 255 output,
@BASECURRENCYID uniqueidentifier = null output,
@SITEID uniqueidentifier = null output -- obsolete
)
as
set nocount on;
declare @POS int = charindex('|', @CONTEXT, 1);
set @BASECURRENCYID = null;
set @SITEID = null;
if @POS > 0
begin
set @MAILINGTYPECODE = convert(tinyint, substring(@CONTEXT, 1, @POS - 1));
set @BASECURRENCYID = convert(uniqueidentifier, substring(@CONTEXT, @POS + 1, 36));
end
else
set @MAILINGTYPECODE = convert(tinyint, @CONTEXT);
return 0;