UFN_MKTSEGMENTATIONSEGMENTCACHEADDRESSES_MAKETABLENAME

Returns the name of the marketing effort segment address cache table for a record source.

Return

Return Type
nvarchar(73)

Parameters

Parameter Parameter Type Mode Description
@SEGMENTATIONID uniqueidentifier IN

Definition

Copy


CREATE function dbo.[UFN_MKTSEGMENTATIONSEGMENTCACHEADDRESSES_MAKETABLENAME]
(
  @SEGMENTATIONID uniqueidentifier
)
returns nvarchar(73)
as
begin
  return 'MKTSEGMENTATIONSEGMENTCACHEADDRESSES_' + replace(cast(@SEGMENTATIONID as nvarchar(36)), '-', '_');
end