Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Stackoverflow ms sql update by order using cte not working, why?

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 8, rows affected: 11, absolute service time: 0,17 sec 
fork mode |  history 
  
Id
Serial



1
1
1001



2
2
1002



3
3
1003



4
4
1005



5
5
1006



6
6
1007



7
7
1004






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development