UFN_DIRECTMARKETINGEFFORTBATCHTESTSEGMENT_GETNAME

CREATE function dbo.[UFN_DIRECTMARKETINGEFFORTBATCHTESTSEGMENT_GETNAME]
(
  @ID uniqueidentifier
)
returns nvarchar(100)
as
begin
  declare @NAME nvarchar(203);

  if @ID is null
    return '';

  if exists(select * from dbo.[MKTSEGMENTATIONTESTSEGMENT] where [ID] = @ID)
    set @NAME = dbo.[UFN_MKTSEGMENTATIONTESTSEGMENT_GETNAME](@ID);
  else
    set @NAME = isnull((select [NAME] from dbo.[BATCHDIRECTMARKETINGEFFORTTESTSEGMENT] where [ID] = @ID), '');

  return @NAME;
end