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