title: SQL Server Rounding Issue where there is 5
body: <p>As far as i know according to mathematics rounding should work as below when rounding number is 5.</p>
  
  <pre><code>2.435 =&gt; 2.44 (Round Up, if rounding to digit(3) is odd number)
  2.445 =&gt; 2.44 (Round Down, if rounding to digit(4) is even number)
  </code></pre>
  
  <p>if we do summation all fine, </p>
  
  <pre><code>2.435 + 2.445 =  4.88
  2.44 + 2.44 = 4.88 
  </code></pre>
  
  <p>I'm pretty sure in .Net also rounding works like this.</p>
  
  <p>But in SQL server, 5 is always rounding up which is not correct according to maths.</p>
  
  <pre><code>SELECT round(2.345, 2)  = 2.35
  SELECT round(2.335, 2) =&gt; 2.34
  </code></pre>
  
  <p>this results to 1 cent discrepancies in summation of rounded values.</p>
  
  <pre><code>2.345 + 2.335 = 4.68
  2.35 + 2.34 = 4.69 =&gt; which is not correct
  </code></pre>
  
  <p>I have tried this with decimal and money data types.</p>
  
  <p>Am i doing something wrong? Is there a work around for this?</p>