UFN_MKTSEGMENTATIONTESTSEGMENT_BUILDNAME

Returns a marketing effort segment test segment's name, given the relevant data.

Return

Return Type
nvarchar(203)

Parameters

Parameter	Parameter Type	Mode
@PREFIXCODE	tinyint	IN
@TESTSEGMENTNAME	nvarchar(100)	IN
@SEGMENTNAME	nvarchar(100)	IN
@SEGMENTCODE	nvarchar(10)	IN

Definition

Copy



CREATE function dbo.[UFN_MKTSEGMENTATIONTESTSEGMENT_BUILDNAME]
(
  @PREFIXCODE tinyint,
  @TESTSEGMENTNAME nvarchar(100),
  @SEGMENTNAME nvarchar(100),
  @SEGMENTCODE nvarchar(10)
)
returns nvarchar(203)
as
begin
  return
  (
    isnull(
      (case @PREFIXCODE
        when 0 then
          -- No prefix

          @TESTSEGMENTNAME
        when 1 then
          -- Segment name

          @SEGMENTNAME + ' - ' + @TESTSEGMENTNAME
        when 2 then
          -- Segment code

          @SEGMENTCODE + ' - ' + @TESTSEGMENTNAME
       end), '')
  );
end