USP_DATAFORMTEMPLATE_EDIT_BBAIMPORTFILES_2

                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BBAIMPORTFILES_2 (
                        @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,
                        @ANALYTICSPROJECTID uniqueidentifier
                    ) as
                        set nocount on;

                        declare @CURRENTDATE datetime;
                        set @CURRENTDATE = getdate();

                        if @CHANGEAGENTID is null
                            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                        set @ID = null;

                        select top 1
                            @ID = ID
                        from
                            dbo.BBAIMPORTFILES;

                        begin try
                            if @ID is null begin
                                insert into dbo.BBAIMPORTFILES (
                                    ID,
                                    CONSTITUENTFILE,
                                    CONSTITUENTFILENAME,
                                    CONSTITUENTFILESTATUSCODE,

                                    SUGGESTEDMEMBERSHIPLEVELSFILE,
                                    SUGGESTEDMEMBERSHIPLEVELSFILENAME,
                                    SUGGESTEDMEMBERSHIPLEVELSFILESTATUSCODE,

                                    TARGETGIFTRANGESFILE,
                                    TARGETGIFTRANGESFILENAME,
                                    TARGETGIFTRANGESFILESTATUSCODE,

                                    WEALTHESTIMATORRATINGSFILE,
                                    WEALTHESTIMATORRATINGSFILENAME,
                                    WEALTHESTIMATORRATINGSFILESTATUSCODE,

                                    MODELINGANDPROPENSITYFILE,
                                    MODELINGANDPROPENSITYFILENAME,
                                    MODELINGANDPROPENSITYFILESTATUSCODE,

                                    ANALYTICSPROJECTID,

                                    ADDEDBYID,
                                    CHANGEDBYID,
                                    DATEADDED,
                                    DATECHANGED
                                ) values (
                                    newid(),
                                    @CONSTITUENTFILE,
                                    @DISPLAYEDCONSTITUENTFILENAME,
                                    case when len(@DISPLAYEDCONSTITUENTFILENAME) > 0 then 1 else 0 end,

                                    @SUGGESTEDMEMBERSHIPLEVELSFILE,
                                    @DISPLAYEDSUGGESTEDMEMBERSHIPLEVELSFILENAME,
                                    case when len(@DISPLAYEDSUGGESTEDMEMBERSHIPLEVELSFILENAME) > 0 then 1 else 0 end,

                                    @TARGETGIFTRANGESFILE,
                                    @DISPLAYEDTARGETGIFTRANGESFILENAME,
                                    case when len(@DISPLAYEDTARGETGIFTRANGESFILENAME) > 0 then 1 else 0 end,

                                    @WEALTHESTIMATORRATINGSFILE,
                                    @DISPLAYEDWEALTHESTIMATORRATINGSFILENAME,
                                    case when len(@DISPLAYEDWEALTHESTIMATORRATINGSFILENAME) > 0 then 1 else 0 end,

                                    @MODELINGANDPROPENSITYFILE,
                                    @DISPLAYEDMODELINGANDPROPENSITYFILENAME,
                                    case when len(@DISPLAYEDMODELINGANDPROPENSITYFILENAME) > 0 then 1 else 0 end,

                                    @ANALYTICSPROJECTID,

                                    @CHANGEAGENTID,
                                    @CHANGEAGENTID,
                                    @CURRENTDATE,
                                    @CURRENTDATE
                                );
                            end
                            else begin
                                update
                                    dbo.BBAIMPORTFILES
                                set
                                    CONSTITUENTFILE = case @CONSTITUENTFILECHANGED when 1 then @CONSTITUENTFILE else BBAIMPORTFILES.CONSTITUENTFILE end,
                                    CONSTITUENTFILENAME = case @CONSTITUENTFILECHANGED when 1 then @DISPLAYEDCONSTITUENTFILENAME else BBAIMPORTFILES.CONSTITUENTFILENAME end,
                                    CONSTITUENTFILESTATUSCODE = case when @CONSTITUENTFILECHANGED = 1 and len(@DISPLAYEDCONSTITUENTFILENAME) <= 0 then 0 when @CONSTITUENTFILECHANGED = 1 and len(@DISPLAYEDCONSTITUENTFILENAME) > 0 then 1 else BBAIMPORTFILES.CONSTITUENTFILESTATUSCODE end,
                                    CONSTITUENTFILEERRORS = case @CONSTITUENTFILECHANGED when 1 then '' else BBAIMPORTFILES.CONSTITUENTFILEERRORS end,

                                    SUGGESTEDMEMBERSHIPLEVELSFILE = case @SUGGESTEDMEMBERSHIPLEVELSFILECHANGED when 1 then @SUGGESTEDMEMBERSHIPLEVELSFILE else BBAIMPORTFILES.SUGGESTEDMEMBERSHIPLEVELSFILE end,
                                    SUGGESTEDMEMBERSHIPLEVELSFILENAME = case @SUGGESTEDMEMBERSHIPLEVELSFILECHANGED when 1 then @DISPLAYEDSUGGESTEDMEMBERSHIPLEVELSFILENAME else BBAIMPORTFILES.SUGGESTEDMEMBERSHIPLEVELSFILENAME end,
                                    SUGGESTEDMEMBERSHIPLEVELSFILESTATUSCODE = case when @SUGGESTEDMEMBERSHIPLEVELSFILECHANGED = 1 and len(@DISPLAYEDSUGGESTEDMEMBERSHIPLEVELSFILENAME) <= 0 then 0 when @SUGGESTEDMEMBERSHIPLEVELSFILECHANGED = 1 and len(@DISPLAYEDSUGGESTEDMEMBERSHIPLEVELSFILENAME) > 0 then 1 else BBAIMPORTFILES.SUGGESTEDMEMBERSHIPLEVELSFILESTATUSCODE end,
                                    SUGGESTEDMEMBERSHIPLEVELSFILEERRORS = case @SUGGESTEDMEMBERSHIPLEVELSFILECHANGED when 1 then '' else BBAIMPORTFILES.SUGGESTEDMEMBERSHIPLEVELSFILEERRORS end,

                                    TARGETGIFTRANGESFILE = case @TARGETGIFTRANGESFILECHANGED when 1 then @TARGETGIFTRANGESFILE else BBAIMPORTFILES.TARGETGIFTRANGESFILE end,
                                    TARGETGIFTRANGESFILENAME = case @TARGETGIFTRANGESFILECHANGED when 1 then @DISPLAYEDTARGETGIFTRANGESFILENAME else BBAIMPORTFILES.TARGETGIFTRANGESFILENAME end,
                                    TARGETGIFTRANGESFILESTATUSCODE = case when @TARGETGIFTRANGESFILECHANGED = 1 and len(@DISPLAYEDTARGETGIFTRANGESFILENAME) <= 0 then 0 when @TARGETGIFTRANGESFILECHANGED = 1 and len(@DISPLAYEDTARGETGIFTRANGESFILENAME) > 0 then 1 else BBAIMPORTFILES.TARGETGIFTRANGESFILESTATUSCODE end,
                                    TARGETGIFTRANGESFILEERRORS = case @TARGETGIFTRANGESFILECHANGED when 1 then '' else BBAIMPORTFILES.TARGETGIFTRANGESFILEERRORS end,

                                    WEALTHESTIMATORRATINGSFILE = case @WEALTHESTIMATORRATINGSFILECHANGED when 1 then @WEALTHESTIMATORRATINGSFILE else BBAIMPORTFILES.WEALTHESTIMATORRATINGSFILE end,
                                    WEALTHESTIMATORRATINGSFILENAME = case @WEALTHESTIMATORRATINGSFILECHANGED when 1 then @DISPLAYEDWEALTHESTIMATORRATINGSFILENAME else BBAIMPORTFILES.WEALTHESTIMATORRATINGSFILENAME end,
                                    WEALTHESTIMATORRATINGSFILESTATUSCODE = case when @WEALTHESTIMATORRATINGSFILECHANGED = 1 and len(@DISPLAYEDWEALTHESTIMATORRATINGSFILENAME) <= 0 then 0 when @WEALTHESTIMATORRATINGSFILECHANGED = 1 and len(@DISPLAYEDWEALTHESTIMATORRATINGSFILENAME) > 0 then 1 else BBAIMPORTFILES.WEALTHESTIMATORRATINGSFILESTATUSCODE end,
                                    WEALTHESTIMATORRATINGSFILEERRORS = case @WEALTHESTIMATORRATINGSFILECHANGED when 1 then '' else BBAIMPORTFILES.WEALTHESTIMATORRATINGSFILEERRORS end,

                                    MODELINGANDPROPENSITYFILE = case @MODELINGANDPROPENSITYFILECHANGED when 1 then @MODELINGANDPROPENSITYFILE else BBAIMPORTFILES.MODELINGANDPROPENSITYFILE end,
                                    MODELINGANDPROPENSITYFILENAME = case @MODELINGANDPROPENSITYFILECHANGED when 1 then @DISPLAYEDMODELINGANDPROPENSITYFILENAME else BBAIMPORTFILES.MODELINGANDPROPENSITYFILENAME end,
                                    MODELINGANDPROPENSITYFILESTATUSCODE = case
                                                                            when @MODELINGANDPROPENSITYFILECHANGED = 1 and len(@DISPLAYEDMODELINGANDPROPENSITYFILENAME) <= 0 then 0
                                                                            when @MODELINGANDPROPENSITYFILECHANGED = 1 and len(@DISPLAYEDMODELINGANDPROPENSITYFILENAME) > 0 then 1
                                                                            when MODELINGANDPROPENSITYFILEERRORS is not null and MODELINGANDPROPENSITYFILEERRORS.exist('/*') = 1 and ANALYTICSPROJECTID is null and @ANALYTICSPROJECTID is not null then 1
                                                                            else BBAIMPORTFILES.MODELINGANDPROPENSITYFILESTATUSCODE
                                                                          end,
                                    MODELINGANDPROPENSITYFILEERRORS = case
                                                                        when @MODELINGANDPROPENSITYFILECHANGED = 1 then ''
                                                                        when ANALYTICSPROJECTID is null and @ANALYTICSPROJECTID is not null then ''
                                                                        else BBAIMPORTFILES.MODELINGANDPROPENSITYFILEERRORS
                                                                      end,

                                    ANALYTICSPROJECTID = @ANALYTICSPROJECTID,

                                    CHANGEDBYID = @CHANGEAGENTID,
                                    DATECHANGED = @CURRENTDATE
                                from
                                    dbo.BBAIMPORTFILES
                                where
                                    ID = @ID;
                            end
                        end try
                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                            return 1;
                        end catch

                        return 0;