UFN_MKTEXPORTDEFINITION_GETNAMEFROMNETCOMMUNITYDATASOURCEID

CREATE function dbo.[UFN_MKTEXPORTDEFINITION_GETNAMEFROMNETCOMMUNITYDATASOURCEID]
(
  @ID integer
)
returns nvarchar(100)
as
begin
  if @ID is null or @ID = 0
    return '';

  declare @NAME nvarchar(100);

  if exists (select top 1 1 from dbo.[MKTEXPORTDEFINITION] where [NETCOMMUNITYDATASOURCEID] = @ID and [EXPORTDEFINITIONID] is not null)
    select @NAME = [EXPORTDEFINITION].[NAME] from dbo.[EXPORTDEFINITION] inner join dbo.[MKTEXPORTDEFINITION] on [MKTEXPORTDEFINITION].[EXPORTDEFINITIONID] = [EXPORTDEFINITION].[ID] where [MKTEXPORTDEFINITION].[NETCOMMUNITYDATASOURCEID] = @ID;
  else
    select @NAME = [NAME] from dbo.[MKTEXPORTDEFINITION] where [NETCOMMUNITYDATASOURCEID] = @ID;

  return @NAME;
end