title: Division of 2 numbers using CAST function in SQL server 2008R2
body: <p>I have two numbers I want to divide: 5262167 / 162333331 When verified using windows calculator (calc.exe) the result is 0.0324158136076195 but when used simple select with CAST function in SQL Server 2008R2 I don't have same result. Here is what I'm running in SQL editor: </p>
  
  <pre><code>select CAST((5262167 / 162333331) as decimal(18,8))
  </code></pre>
  
  <p>and the result is 0.00000000</p>