title: SQL Server Subquery returned more than 1 value. This is not permitted when the subquery follows (chars) or when the subquery is used as an expression
body: <p>I am trying to update some fields based on their occurence. If they only occur one time, I am updating some status field.</p>
  
  <p>My current code is as follows:</p>
  
  <pre><code>UPDATE table1
  SET statusField = 1
  WHERE someID = (
                 SELECT someID
                 FROM table1
                 GROUP BY someID HAVING COUNT(*) = 1
                 )
  </code></pre>
  
  <p>This returns an error like the one in the title: <code>Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, &lt;, &lt;= , &gt;, &gt;= or when the subquery is used as an expression.</code></p>
  
  <p>Is there any other, as easily readable/simple, solution to this?</p>