title: SQL Decimal formatting not working properly in all cases
body: <p>SQL Server decimal function not working as intended.</p>
  
  <p>To test with sample data, I created a table and inserted values to it.
  Then, I tried to run decimal function on these values.</p>
  
  <pre><code>CREATE TABLE TEST_VAL
  (
     VAL float
  )
  
  SELECT * FROM TEST_VAL
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>VAL
  ----------
  16704.405
  20382.135
   2683.135
  
  SELECT CAST(VAL AS DECIMAL(15, 2)) AS NEWVAL 
  FROM TEST_VAL;
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>NEWVAL
  -------------
  16704.40
  20382.13
   2683.14
  </code></pre>
  
  <p>I expected same formatting for all 3 values. But, for third value it returns ceiling round off value.</p>