Bulk update rows using CASE expressions.

Answer preview

One statement, one pass: a CASE expression inside SET computes a different multiplier per row, so there is no need for two UPDATEs.…