title: Converting a FLOAT to an INT
body: <p>I first tried to cast my data from a float to an int using the <code>ROUND</code> function. I rounded the float data to a whole number, which is great. </p>
  
  <p>I next tried to insert the float data from 1 column (<code>totexunits</code>) to another column which is an <code>int</code> (<code>Units</code>). I am getting the below message:</p>
  
  <pre><code>Msg 232, Level 16, State 3, Line 1
  Arithmetic overflow error for type int, value = 5726577093.000000.
  </code></pre>
  
  <p>I used this sql:</p>
  
  <pre><code>update wkimport2 set units = CONVERT(int, totexunits)
  </code></pre>
  
  <p>I am not sure whats going on. I checked that number in the database, and it does show any decimal places, yet it acts like there are some decimal places. Anyone know how I can get the column from <code>totexunits</code> to populate the units column? I'm stuck. </p>