USP_SIMPLEDATALIST_MKTEXPORTDEFINITIONNETCOMMUNITYDATASOURCE

CREATE procedure dbo.[USP_SIMPLEDATALIST_MKTEXPORTDEFINITIONNETCOMMUNITYDATASOURCE]
(
  @MAILINGTYPECODE tinyint = null
)
as
  begin
      set nocount on;

    declare @RECORDTYPEID uniqueidentifier;

    if @MAILINGTYPECODE is not null and @MAILINGTYPECODE <> 255
      set @RECORDTYPEID = dbo.[UFN_MKTEXPORTDEFINITION_GETRECORDTYPEIDFROMMAILINGTYPECODE](@MAILINGTYPECODE);

      select distinct
          [MKTEXPORTDEFINITION].[NETCOMMUNITYDATASOURCEID] as [VALUE],
          [EXPORTDEFINITION].[NAME] as [LABEL]
      from dbo.[MKTEXPORTDEFINITION]
    inner join dbo.[EXPORTDEFINITION] on [EXPORTDEFINITION].[ID] = [MKTEXPORTDEFINITION].[EXPORTDEFINITIONID]
      where [MKTEXPORTDEFINITION].[NETCOMMUNITYDATASOURCEID] > 0
        and (@RECORDTYPEID is null or [EXPORTDEFINITION].[RECORDTYPEID] = @RECORDTYPEID)
        and [EXPORTDEFINITION].[ISSYSTEM] = 0
      order by [EXPORTDEFINITION].[NAME];

      return 0;
  end;