USP_DATAFORMTEMPLATE_EDIT_BBAIMPORTFILES

The save procedure used by the edit dataform template "Target Analytics Import Files Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CONSTITUENTFILE	varbinary	IN	Constituents
@CONSTITUENTFILENAME	nvarchar(255)	IN	Constituents
@DISPLAYEDCONSTITUENTFILENAME	nvarchar(255)	IN	Constituents
@CONSTITUENTFILECHANGED	bit	IN	Constituent file changed?
@SUGGESTEDMEMBERSHIPLEVELSFILE	varbinary	IN	Suggested membership levels
@SUGGESTEDMEMBERSHIPLEVELSFILENAME	nvarchar(255)	IN	Suggested membership levels
@DISPLAYEDSUGGESTEDMEMBERSHIPLEVELSFILENAME	nvarchar(255)	IN	Suggested membership levels
@SUGGESTEDMEMBERSHIPLEVELSFILECHANGED	bit	IN	Suggested membership levels file changed?
@TARGETGIFTRANGESFILE	varbinary	IN	Target gift ranges
@TARGETGIFTRANGESFILENAME	nvarchar(255)	IN	Target gift ranges
@DISPLAYEDTARGETGIFTRANGESFILENAME	nvarchar(255)	IN	Target gift ranges
@TARGETGIFTRANGESFILECHANGED	bit	IN	Target gift ranges file changed?
@WEALTHESTIMATORRATINGSFILE	varbinary	IN	Wealth estimator ratings
@WEALTHESTIMATORRATINGSFILENAME	nvarchar(255)	IN	Wealth estimator ratings
@DISPLAYEDWEALTHESTIMATORRATINGSFILENAME	nvarchar(255)	IN	Wealth estimator ratings
@WEALTHESTIMATORRATINGSFILECHANGED	bit	IN	Wealth estimator ratings file changed?
@MODELINGANDPROPENSITYFILE	varbinary	IN	Modeling and propensity
@MODELINGANDPROPENSITYFILENAME	nvarchar(255)	IN	Modeling and propensity
@DISPLAYEDMODELINGANDPROPENSITYFILENAME	nvarchar(255)	IN	Modeling and propensity
@MODELINGANDPROPENSITYFILECHANGED	bit	IN	Modeling and propensity file changed?

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_BBAIMPORTFILES
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CONSTITUENTFILE varbinary(max),
    @CONSTITUENTFILENAME nvarchar(255),
    @DISPLAYEDCONSTITUENTFILENAME nvarchar(255),
    @CONSTITUENTFILECHANGED bit,
    @SUGGESTEDMEMBERSHIPLEVELSFILE varbinary(max),
    @SUGGESTEDMEMBERSHIPLEVELSFILENAME nvarchar(255),
    @DISPLAYEDSUGGESTEDMEMBERSHIPLEVELSFILENAME nvarchar(255),
    @SUGGESTEDMEMBERSHIPLEVELSFILECHANGED bit,
    @TARGETGIFTRANGESFILE varbinary(max),
    @TARGETGIFTRANGESFILENAME nvarchar(255),
    @DISPLAYEDTARGETGIFTRANGESFILENAME nvarchar(255),
    @TARGETGIFTRANGESFILECHANGED bit,
    @WEALTHESTIMATORRATINGSFILE varbinary(max),
    @WEALTHESTIMATORRATINGSFILENAME nvarchar(255),
    @DISPLAYEDWEALTHESTIMATORRATINGSFILENAME nvarchar(255),
    @WEALTHESTIMATORRATINGSFILECHANGED bit,
    @MODELINGANDPROPENSITYFILE varbinary(max),
    @MODELINGANDPROPENSITYFILENAME nvarchar(255),
    @DISPLAYEDMODELINGANDPROPENSITYFILENAME nvarchar(255),
    @MODELINGANDPROPENSITYFILECHANGED bit
)

as
  set nocount on;

    declare @ANALYTICSPROJECTID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BBAIMPORTFILES_LOAD
        @ID = @ID,
        @ANALYTICSPROJECTID = @ANALYTICSPROJECTID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_BBAIMPORTFILES_2
        @ID,
        @CHANGEAGENTID,
        @CONSTITUENTFILE,
        @CONSTITUENTFILENAME,
        @DISPLAYEDCONSTITUENTFILENAME,
        @CONSTITUENTFILECHANGED,
        @SUGGESTEDMEMBERSHIPLEVELSFILE,
        @SUGGESTEDMEMBERSHIPLEVELSFILENAME,
        @DISPLAYEDSUGGESTEDMEMBERSHIPLEVELSFILENAME,
        @SUGGESTEDMEMBERSHIPLEVELSFILECHANGED,
        @TARGETGIFTRANGESFILE,
        @TARGETGIFTRANGESFILENAME,
        @DISPLAYEDTARGETGIFTRANGESFILENAME,
        @TARGETGIFTRANGESFILECHANGED,
        @WEALTHESTIMATORRATINGSFILE,
        @WEALTHESTIMATORRATINGSFILENAME,
        @DISPLAYEDWEALTHESTIMATORRATINGSFILENAME,
        @WEALTHESTIMATORRATINGSFILECHANGED,
        @MODELINGANDPROPENSITYFILE,
        @MODELINGANDPROPENSITYFILENAME,
        @DISPLAYEDMODELINGANDPROPENSITYFILENAME,
        @MODELINGANDPROPENSITYFILECHANGED,
        @ANALYTICSPROJECTID

  return 0;