UFN_MKTSEGMENTATIONTESTSEGMENT_GETNAME

CREATE function dbo.[UFN_MKTSEGMENTATIONTESTSEGMENT_GETNAME]
(
  @ID uniqueidentifier
)
returns nvarchar(203)
as
begin
  return
  (
    select isnull(
      (case [MKTSEGMENTATIONTESTSEGMENT].[PREFIXCODE]
        when 0 then
          -- No prefix

          [MKTSEGMENTATIONTESTSEGMENT].[NAME]
        when 1 then
          -- Segment name

          [MKTSEGMENT].[NAME] + ' - ' + [MKTSEGMENTATIONTESTSEGMENT].[NAME]
        when 2 then
          -- Segment code

          [MKTSEGMENT].[CODE] + ' - ' + [MKTSEGMENTATIONTESTSEGMENT].[NAME]
       end), '')
    from dbo.[MKTSEGMENTATIONTESTSEGMENT]
    left join dbo.[MKTSEGMENTATIONSEGMENT] on [MKTSEGMENTATIONSEGMENT].[ID] = [MKTSEGMENTATIONTESTSEGMENT].[SEGMENTID]
    left join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTID]
    where [MKTSEGMENTATIONTESTSEGMENT].[ID] = @ID
  );
end