UFN_MKTEXPORTDEFINITION_GETDATALIST

CREATE function dbo.[UFN_MKTEXPORTDEFINITION_GETDATALIST]
(
  @MAILINGTYPECODE tinyint
)
returns table
as
  return
  (
    select
      [MKTEXPORTDEFINITION].[ID],
      [MKTEXPORTDEFINITION].[NAME],
      convert(bit, 0) as [INUSE], -- these are obsolete

      (select count([QUERYFIELD]) from dbo.[MKTEXPORTDEFINITIONOUTPUTFIELD] where [EXPORTDEFINITIONID] = [MKTEXPORTDEFINITION].[ID]) as [FIELDCOUNT],
      dbo.[UFN_MKTPOSTALTEMPLATE_GETNAME]([MKTEXPORTDEFINITION].[POSTALTEMPLATEID]) as [POSTALTEMPLATE],
      dbo.[UFN_MKTNETCOMMUNITYINTEGRATION_LINKESTABLISHED]() as [NETCOMMUNITYLINKESTABLISHED]
    from dbo.[MKTEXPORTDEFINITION]
    where [MKTEXPORTDEFINITION].[EXPORTDEFINITIONID] is null
    and [MKTEXPORTDEFINITION].[ISSYSTEM] = 0
    and [MKTEXPORTDEFINITION].[MAILINGTYPECODE] = @MAILINGTYPECODE
  );