USP_FENXT_SAVE_KEYS

            CREATE procedure dbo.USP_FENXT_SAVE_KEYS
                (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @ENVIRONMENTID nvarchar(50),
                @FEDESIGNATIONSOURCE bit
                )
                as
                set nocount on;

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

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

                    begin try
                        merge
                        into dbo.FENXTINTEGRATION
                        using (select @ID as PDACCOUNTSYSTEMID,
                                @CHANGEAGENTID as CHANGEAGENTID,
                                @ENVIRONMENTID as ENVIRONMENTID,
                                @FEDESIGNATIONSOURCE as FEDESIGNATIONSOURCE,
                                @CURRENTDATE as CURRENTDATE) as source
                        on FENXTINTEGRATION.PDACCOUNTSYSTEMID = Source.PDACCOUNTSYSTEMID
                        when matched then
                            update
                                set ENVIRONMENTID = source.ENVIRONMENTID,                
                                FEDESIGNATIONSOURCE = source.FEDESIGNATIONSOURCE,
                                CHANGEDBYID = source.CHANGEAGENTID,
                                DATECHANGED = source.CURRENTDATE
                        when not matched then
                            insert 
                                (ENVIRONMENTID,
                                PDACCOUNTSYSTEMID,
                                FEDESIGNATIONSOURCE,
                                ADDEDBYID, 
                                CHANGEDBYID, 
                                DATEADDED, 
                                DATECHANGED)
                            values
                                (source.ENVIRONMENTID,
                                source.PDACCOUNTSYSTEMID,
                                source.FEDESIGNATIONSOURCE,
                                source.CHANGEAGENTID,
                                source.CHANGEAGENTID,
                                source.CURRENTDATE,
                                source.CURRENTDATE);
                    end try

                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1;
                    end catch

                return 0;