title: How to do a percentage of a column value, and then insert that value into a column
body: <p>The table below should be the output that I want to achieve. That means depending on what value is in column1 which is the percentage and what value is in column2. column1 will do a percentage of column2. Like 80% of 1000 = 800, which will be changed in column2 of 2nd record.</p>
  
  <p>Currently my code only can select the current record and insert another copy which will duplicate the same record. But now I need to calculate and overwrite column 2 values depending on the perentage. I didn't put my select code here as I scared you all will get confused. I only put my insert code here, pls tell me how to do the formula in the code for the percentage for column2 thanks.</p>
  
  <pre><code>Orginal 1st record-&gt;                        column1 column2  
                                              80      1000   
  
  Inserted copy records which is 2nd record   column1 column2  
  (what I want to achieved)                   80      800
  </code></pre>
  
  <p>My codes</p>
  
  <p>INSERT INTO table1 (column1, column2) VALUES (tran.column1, tran.column2);</p>