USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTATIONS_EXPRESSION

The load procedure used by the view dataform template "Marketing Efforts Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ISBBEC	bit	INOUT	Is BBEC?
@ACKNOWLEDGEMENTMAILINGSINSTALLED	bit	INOUT	Is acknowledgement marketing installed?
@MEMBERSHIPMAILINGSINSTALLED	bit	INOUT	Is membership efforts installed
@SPONSORSHIPMAILINGSINSTALLED	bit	INOUT	Is sponsorship efforts installed?
@ISENQUEUESETTINGSSET	bit	INOUT

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTATIONS_EXPRESSION]
(
  @DATALOADED bit = 0 output,
  @ISBBEC bit = null output,
  @ACKNOWLEDGEMENTMAILINGSINSTALLED bit = null output,
  @MEMBERSHIPMAILINGSINSTALLED bit = null output,
  @SPONSORSHIPMAILINGSINSTALLED bit = null output,
  @ISENQUEUESETTINGSSET bit = null output

)
as
  set nocount on;

  set @DATALOADED = 1;
  set @ISBBEC = (case when dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('BB9873D7-F1ED-430A-8AB4-F09F47056538') = 0 then 1 else 0 end);
  set @ACKNOWLEDGEMENTMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_ACKNOWLEDGEMENTMAILINGSINSTALLED]();
  set @MEMBERSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_MEMBERSHIPMAILINGSINSTALLED]();
  set @SPONSORSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_SPONSORSHIPMAILINGSINSTALLED]();

  if exists(select 1 from ENQUEUESETTINGS)
  begin
    set @ISENQUEUESETTINGSSET = 1;
  end
  else
  begin
    set @ISENQUEUESETTINGSSET = 0;
  end

  return 0;