title: how insert data from one column to another sql server
body: <p>I'm having trouble inserting data from one column to another within the same table. I have no problem inserting individual rows but that is not what I want. I have a column called "PercentFull", I am multiplying this value by .01 to get the decimal equivalent, which is what I want to be inserted into a column I've called "NewPercentFull". I have tried the following:</p>
  
  <pre><code>insert into Table1 (NewPercentFull)
  select PercentFull * .01
  from Table 1
  </code></pre>
  
  <p>There is already data that populates the PercentFull column. However, after this query is executed, I get NULL for every column in my table, including the NewPercentFull. Anyone has an idea of how to achieve this? Thanks</p>