Smiddel Posted December 9, 2019 Share Posted December 9, 2019 Dear all, I am trying to update the value of column "action_code" in table "rma" to value HW UPDATE rma 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: SELECT * FROM rma WHERE ID BETWEEN 473576 AND 473621; What am I doing wrong? Thanks in advance! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now