title: What is wrong with this SQL Server query division calculation?
body: <p>I have this table structure on a SQL Server 2008 R2 database:</p>
  
  <pre><code>  CREATE TABLE FormTest
  (   
  clientid char(10),
  DateSelected date,
  A int,
  B int,
  C int
  )
  </code></pre>
  
  <p>I filled the table FormTest with the following information</p>
  
  <pre><code>clientid        DateSelected      A       B     C
  x1              2006-06-09     65150    4921    1
  x2              2006-05-05     155926   69092   1
  x3              2006-01-20     95603    156892  1
  x4              2006-01-20     30704    164741  1
  x4              2006-02-03     65150    174834  1
  x5              2006-04-28     59629    4921    1
  x6              2006-01-27     30704    162356  1
  x7              2006-06-30     65150    4921    1
  x8              2006-07-10     65150    4921    1
  </code></pre>
  
  <p>And finally, I run this sql query:</p>
  
  <pre><code>SELECT clientid, (((a+ b + c) / 3) / 216647 * 10) AS Formula1 
      From FormTest
  </code></pre>
  
  <p>But then I got these results:</p>
  
  <pre><code>clientid        Formula1      
  x1              0
  x2              0
  x3              0
  x4              0
  x4              0
  x5              0
  x6              0
  x7              0
  x8              0
  </code></pre>
  
  <p>Can anybody tell me what am I doing wrong?</p>