Advertisement
SimeonSheytanov

Untitled

Oct 14th, 2016
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.28 KB | None | 0 0
  1. UPDATE Employees
  2. SET ManagerID = 1
  3. WHERE EmployeeID BETWEEN 2 AND 11
  4.  
  5. UPDATE Employees
  6. SET ManagerID = 11
  7. WHERE EmployeeID BETWEEN 12 AND 20
  8.  
  9. UPDATE Employees
  10. SET ManagerID = 21
  11. WHERE EmployeeID BETWEEN 22 AND 30
  12.  
  13. UPDATE Employees
  14. SET ManagerID = 1
  15. WHERE EmployeeID = 21
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement