USP_BBASUGGESTEDMEMBERSHIPLEVELSFILEIMPORT_UPDATE

This procedure is used by the Target Analytics Suggested Membership Levels File Import Record Operation for saving the information from a Target Analytics Target Gift Ranges Import File to the database.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@SCORE	int	IN
@VALUERANGE	nvarchar(50)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_BBASUGGESTEDMEMBERSHIPLEVELSFILEIMPORT_UPDATE (
                @ID uniqueidentifier,
                @SCORE int,
                @VALUERANGE nvarchar(50),
                @CHANGEAGENTID uniqueidentifier
            ) as
                set nocount on;

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

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

                begin try
                    update
                        dbo.SUGGESTEDMEMBERSHIPLEVEL
                    set
                        SCORE = @SCORE,
                        RANGE = @VALUERANGE,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where
                        ID = @ID;
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;