I know how to write an update query toggling binary criteria, but how can I update non-uniform price increases across a product line without losing other data, such as power consumed (which lives in the same table)
Perhaps pricing should be in a related table, instead. Still, I should be able to perform this common task.
