UFN_DIRECTMARKETINGEFFORTBATCHPACKAGE_GETNAME

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

  if @ID is null
    return '';

  if exists(select * from dbo.[MKTPACKAGE] where [ID] = @ID)
    set @NAME = dbo.[UFN_MKTPACKAGE_GETNAME](@ID);
  else
    set @NAME = isnull((select [NAME] from dbo.[BATCHDIRECTMARKETINGEFFORTPACKAGE] where [ID] = @ID), '');

  return @NAME;
end