title: sql update add value one row to another row within the same table
body: <p>SQL update add value one row to another row with in the same table </p>
  
  <pre><code>UPDATE
     artigoArmazem
  SET
    StkActual=  StkActual + StkActual2 
  FROM 
    (Select StkActual FROM artigoArmazem  where artigo='110044' and Localizacao ='VIA1' and lote='&lt;L01&gt;' ) AS StkActual2 
  artigoArmazem
  </code></pre>