TR_APPUSER_UPDATE (Trigger)

                create trigger dbo.TR_APPUSER_UPDATE on dbo.APPUSER after update not for replication
                as begin
                    set nocount on;
                    
                    if update(SITEID) begin
                        declare @ID uniqueidentifier;
                        declare @CHANGEAGENTID uniqueidentifier;
                        
                        declare INSERTED_CURSOR cursor local fast_forward for
                            select
                                ID,
                                CHANGEDBYID
                            from
                                INSERTED;
                                
                        open INSERTED_CURSOR;
                        
                        fetch next from
                            INSERTED_CURSOR
                        into
                            @ID, @CHANGEAGENTID;
                        
                        while @@fetch_status = 0 begin
                            exec dbo.USP_APPUSERSITEBRANCH_UPDATESITES @ID, @CHANGEAGENTID
                            
                            fetch next from
                                INSERTED_CURSOR
                            into
                                @ID,@CHANGEAGENTID;
                        end
                        
                        close INSERTED_CURSOR;
                        deallocate INSERTED_CURSOR;
                    end
                end