title: Update based on select to same table - AGAIN, and AGAIN
body: <p>In Microsoft SQL Server:</p>
  
  <p>I have seen this question several times, but can't see anyone solving the problem:</p>
  
  <pre><code>UPDATE theTable t1
  SET t1.col2 =
      (SELECT (10 * (col1 + col2))
       FROM theTable t2
       WHERE t1.busRelAccount = t2.busRelAccount
       AND t2.rowName = 'POS'
      )
  WHERE t1.busRelAccount = t2.busRelAccount
  AND t1.rowName = 'INVENTORY'
  ;
  </code></pre>
  
  <p>Anyone having solved this problem without using CURSOR and loop the table?</p>