I am trying to update the value of column "action_code" in table "rma" to value HW
SET action_code = 'HW'
WHERE id between 473576 AND 473621;
However it returns this error:
Msg 512, Level 16, State 1, Procedure MODIFY_ESC, Line 5
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
I am able to edit one value at a time. The below query is also able to select the rows in question:
WHERE ID BETWEEN 473576 AND 473621;
What am I doing wrong?
Thanks in advance!