UFN_MKTSEGMENTATIONACTIVATE_MAKETEMPSEGMENTTABLENAME

Returns the name of the temporary segment table used during activation.

Return

Return Type
nvarchar(128)

Parameters

Parameter Parameter Type Mode Description
@SEGMENTID uniqueidentifier IN

Definition

Copy


CREATE function dbo.[UFN_MKTSEGMENTATIONACTIVATE_MAKETEMPSEGMENTTABLENAME]
(
  @SEGMENTID uniqueidentifier
)
returns nvarchar(128)
as
begin
  return '##TEMP_SEGMENT_' + replace(convert(nvarchar(36), @SEGMENTID), '-', '_');
end