USP_DATALIST_EXPORTDEFINITIONFILELAYOUTSUMMARY2

create procedure dbo.[USP_DATALIST_EXPORTDEFINITIONFILELAYOUTSUMMARY2]
(
  @EXPORTDEFINITIONID uniqueidentifier = null
)
as
  set nocount on;

  select
    [EXPORTDEFINITION].[NAME],
    case dbo.[UFN_MKTEXPORTDEFINITION_GETMAILINGTYPECODEFROMRECORDTYPE]([RECORDTYPE].[NAME])
      when 0 then 'Direct marketing'
      when 1 then 'Marketing acknowledgement'
      when 2 then 'Membership renewal'
      when 3 then 'Sponsorship'
    end as [MAILINGTYPE]
  from dbo.[EXPORTDEFINITION]
  inner join dbo.[RECORDTYPE] on [RECORDTYPE].[ID] = [EXPORTDEFINITION].[RECORDTYPEID]
  where [EXPORTDEFINITION].[ID] = @EXPORTDEFINITIONID;

  return 0;