UFN_DIRECTMARKETINGEFFORTBATCHLIST_GETNAME

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

  if @ID is null
    return '';

  if exists(select * from dbo.[MKTLIST] where [ID] = @ID)
    set @NAME = dbo.[UFN_MKTLIST_GETNAME](@ID);
  else
    set @NAME = isnull((select [NAME] from dbo.[BATCHDIRECTMARKETINGEFFORTLIST] where [ID] = @ID), '');

  return @NAME;
end