title: Get an accurate percentage calculation
body: <p>I am trying to divide one number by another in a SQL view.  I'm dividing two columns that are each of type <code>int</code>, and the problem is that its giving me a rounded output, rather than an accurate one.</p>
  
  <p>Here is my select:</p>
  
  <pre><code>SELECT numberOne, numberTwo, (numberOne*100/NULLIF(numberTwo, 0)) as PctOutput
  </code></pre>
  
  <p>This is working, but when it dives 3 by 37 its giving me 8 instead of 8.108.</p>
  
  <p>How would I modify this to give me an accurate answer?  Do I need to cast the  numbers out of ints?  if so - into what?</p>