UPDATE Ware SET Ware.Type = Ware.SortNumber + 9 FROM Ware WITH (NOLOCK)
INNER JOIN WareGroups WITH (NOLOCK) ON WareGroups.WareGroupNumber = Ware.WareGroupNumber
  AND WareGroups.Payment = 5  -- Provision
WHERE Ware.SortNumber <= 10