Jump to content

Smiddel

Members
  • Posts

    1
  • Joined

  • Last visited

Everything posted by Smiddel

  1. Smiddel

    Updat error

    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!
×
×
  • Create New...