Jump to content

Updat error


Smiddel

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...