UFN_MKTSEGMENTLIST_GETNAME

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.[UFN_MKTSEGMENTLIST_GETNAME]
(
  @ID uniqueidentifier
)
returns nvarchar(100)
as begin
  if @ID is null
    return '';

  return coalesce((select dbo.[UFN_MKTSEGMENT_GETNAME]([SEGMENTID])
                   from dbo.[MKTSEGMENTLIST]
                   where [ID] = @ID), '');
end