USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTATIONPASSIVES_EXPRESSION

Parameters

Parameter Parameter Type Mode Description
@DATALOADED bit INOUT
@ACKNOWLEDGEMENTMAILINGSINSTALLED bit INOUT
@MEMBERSHIPMAILINGSINSTALLED bit INOUT
@SPONSORSHIPMAILINGSINSTALLED bit INOUT

Definition

Copy

create procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_MKTSEGMENTATIONPASSIVES_EXPRESSION]
(
  @DATALOADED bit = 0 output,
  @ACKNOWLEDGEMENTMAILINGSINSTALLED bit = null output,
  @MEMBERSHIPMAILINGSINSTALLED bit = null output,
  @SPONSORSHIPMAILINGSINSTALLED bit = null output
)
as
  set nocount on;

  set @DATALOADED = 1;
  set @ACKNOWLEDGEMENTMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_ACKNOWLEDGEMENTMAILINGSINSTALLED]();
  set @MEMBERSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_MEMBERSHIPMAILINGSINSTALLED]();
  set @SPONSORSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_SPONSORSHIPMAILINGSINSTALLED]();

  return 0;