UFN_MKTEXPORTDEFINITION_GETIDFROMNETCOMMUNITYDATASOURCEID

CREATE function dbo.[UFN_MKTEXPORTDEFINITION_GETIDFROMNETCOMMUNITYDATASOURCEID]
(
  @ID integer
)
returns uniqueidentifier
as
begin
  if @ID is null or @ID = 0
    return null;

  declare @EXPORTDEFINITIONID uniqueidentifier;

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

  return @EXPORTDEFINITIONID;
end