USP_SURVEYDOWNLOADPROCESS_UPDATEENDPOINT

Updates the current end point used by the Blackbaud Internet Solutions survey download process.

Parameters

Parameter	Parameter Type	Mode	Description
@NEWENDPOINT	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_SURVEYDOWNLOADPROCESS_UPDATEENDPOINT
            (
                @NEWENDPOINT datetime,
                @CHANGEAGENTID uniqueidentifier
            )
            as
            set nocount on;

            begin try
                if @CHANGEAGENTID is null 
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
                declare @CHANGEDATE datetime;
                set @CHANGEDATE = getdate();

                update dbo.SURVEYDOWNLOADPROCESS
                    set CURRENTENDPOINT = @NEWENDPOINT,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CHANGEDATE
                where ID = 'CE06A9F5-8A55-4294-B041-90A58AC83F73';

                if @@ROWCOUNT = 0
                    insert into dbo.SURVEYDOWNLOADPROCESS(ID, CURRENTENDPOINT, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                            values('CE06A9F5-8A55-4294-B041-90A58AC83F73', @NEWENDPOINT, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE);
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;