TR_APPUSER_INSERT (Trigger)

                create trigger dbo.TR_APPUSER_INSERT on dbo.APPUSER after insert not for replication
                as begin
                    set nocount on;
                        
                    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