title: Sql stored procedure to update empty column
body: <p>This is my table</p>
  
  <pre><code>  FundId  Fund   Industry State    Column1
       1     1        2      NSW             
       2     1        2      ACT         
       3     1        2      VIC          
       4     1        2      NSW         
       5     1        2      ACT         
       6     1        2      VIC         
       7     1        2      NSW          
       8     1        2      ACT         
       9     1        2      VIC      
  </code></pre>
  
  <p>Currently the Column1 is empty which is a calculated column. It is calculated as </p>
  
  <pre><code>   Column1: fund*5
  </code></pre>
  
  <p>Below is the query to calculate Column1</p>
  
  <pre><code> SELECT Fund,
             Industry,
             State,
             Fund * 5 AS Column1
      FROM fundDetails
  </code></pre>
  
  <p>The query is working fine. But i want to updated the empty Column1 using stored procedure. </p>
  
  <p>How can I update the <code>column1</code> .</p>
  
  <p>Any help would be appreciated.</p>