title: Using the decimal format (5,2) with a calculation 1/100 SQL
body: <p>I am having trouble and I don't believe it is syntax related as the same syntax for different calculations work correctly...</p>
  <p>Theory:</p>
  <pre><code>SELECT CONVERT(DECIMAL(5,2), (1 / 100)) 
  </code></pre>
  <p>This returns 0.00 the actual answer is 0.01</p>
  <p>Example (denominator is 100):</p>
  <pre><code>select CONVERT(DECIMAL(5,2), (1/P.denominator))  
  From dl.Product_UnitOfMeasure p
  Where p.[SKUVariant] = 'ME000965.00'
  And   p.[UOM] = 'PAC';
  </code></pre>
  <p>This returns 0.00 the actual answer is 0.01</p>
  <p>Any help would be greatly appreciated.</p>