Update Employees1 Set ManagerID = 8 Where EmployeeName IN ('Mark', 'Steve', 'Lara') Update Employees1 Set ManagerID = 2 Where EmployeeName IN ('Stacy', 'Simon') Update Employees1 Set ManagerID = 3 ...