USP_DATAFORMTEMPLATE_VIEW_MKTEXPORTDEFINITIONS

The load procedure used by the view dataform template "Export Definitions Page View"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@ACKNOWLEDGEMENTMAILINGSINSTALLED	bit	INOUT	Marketing Acknowledgements installed?
@MEMBERSHIPMAILINGSINSTALLED	bit	INOUT	Membership renewal efforts installed?
@SPONSORSHIPMAILINGSINSTALLED	bit	INOUT	Sponsorship efforts installed?
@NETCOMMUNITYLINKESTABLISHED	bit	INOUT	Blackbaud Internet Solutions link established?
@CONSOLIDATEDQUERYVIEWEXISTS	bit	INOUT	Consolidated query view exists?

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTEXPORTDEFINITIONS]
(
  @DATALOADED bit = 0 output,
  @ACKNOWLEDGEMENTMAILINGSINSTALLED bit = null output,
  @MEMBERSHIPMAILINGSINSTALLED bit = null output,
  @SPONSORSHIPMAILINGSINSTALLED bit = null output,
  @NETCOMMUNITYLINKESTABLISHED bit = null output,
  @CONSOLIDATEDQUERYVIEWEXISTS bit = null output
)
as
  begin
    set @ACKNOWLEDGEMENTMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_ACKNOWLEDGEMENTMAILINGSINSTALLED]();
    set @MEMBERSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_MEMBERSHIPMAILINGSINSTALLED]();
    set @SPONSORSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_SPONSORSHIPMAILINGSINSTALLED]();
    set @NETCOMMUNITYLINKESTABLISHED = dbo.[UFN_MKTNETCOMMUNITYINTEGRATION_LINKESTABLISHED]();

    set @CONSOLIDATEDQUERYVIEWEXISTS = case when exists (select top 1 1 from dbo.[MKTCONSOLIDATEDQUERYVIEWSPEC]) then 1 else 0 end;

    set @DATALOADED = 1;

    return 0;
  end