title: SQL rounding from 3 decimals to 2 decimals
body: <p>I Have an SSRS 2008 Report whose dataset runs a SQL query that returns a calculated column.  This dataset fills a table in the report.  </p>
  
  <p>The calculated column is returning up to 4 decimals.  I want to round to the nearest 2 decimals.  i.e., 8660.125 should become 8660.13, 1487.8521 should become 1487.85</p>
  
  <p>Sample of the query:</p>
  
  <pre><code>select [Hours] * [Rate] * [Complexity] * [Efficiency] from Hours
  </code></pre>
  
  <p>I would perfer to perform this rounding in the SQL Query rather than the SSRS table because we are trying to keep the tables "unintelligent" so we can encapsulate all our logic in the SQL Query itself.  Suggestions?</p>