title: Returning a zero as value
body: <p>I have the following values within a SQL function that I am tyring to get the calcuation to work.  The values are as follows:</p>
  
  <p>value1: 1.567276144 <p>
  value2: 278576312934.824</p>
  
  <p>The equation is <code>value1 / value2</code></p>
  
  <p>Excel returns the following value: 0.000000000005626020847823060000 (which is correct)</p>
  
  <p>However in SQL-Server it returns:  0.000000000000000 </p>
  
  <p>The datatype is a <code>decimal(38,24)</code></p>
  
  <p>Why does the 12th-15th decimal place not appear?  I know the values is very small but we need percision for our accrediation as we do scientific work.</p>