title: SQL UPDATE: Subquery returned more than 1 value
body: <p>I'm having trouble with this update statement. I'm not sure how to re-phrase it so that for each item in my "in" statement, it updates the rule ID to 109.</p>
  
  <pre><code>UPDATE mytable 
  SET RuleID = 109 
  WHERE mytable.ItemId in (534157, 534154);
  </code></pre>
  
  <p>This fails and gives me the following error:</p>
  
  <blockquote>
    <p>Msg 512, Level 16, State 1, Procedure CLID_Hist, Line 17<br>
    Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &lt;, &lt;= , >, >= or when the subquery is used as an expression.<br>
    The statement has been terminated.</p>
  </blockquote>
  
  <p>I'd appreciate someone's help. For a given list of ItemID's, I want to update the RuleID to 109.</p>
  
  <p>Thank you!</p>