UFN_DIRECTMARKETINGEFFORTBATCHSEGMENT_GETNAME

create function dbo.[UFN_DIRECTMARKETINGEFFORTBATCHSEGMENT_GETNAME]
(
  @ID uniqueidentifier
)
returns nvarchar(100)
as
begin
  declare @NAME nvarchar(100);

  if @ID is null
    return '';

  if exists(select * from dbo.[MKTSEGMENT] where [ID] = @ID)
    set @NAME = dbo.[UFN_MKTSEGMENT_GETNAME](@ID);
  else
    set @NAME = isnull((select [NAME] from dbo.[BATCHDIRECTMARKETINGEFFORTSEGMENT] where [ID] = @ID), '');

  return @NAME;
end