<div>
How to round these result, similar to MROUND in Excel<br />
7.01 &nbsp;-&gt; 7.00<br />
6.75 &nbsp;-&gt; 6.75<br />
6.66 &nbsp;-&gt; 6.65<br />
6.64 &nbsp;-&gt; 6.65<br />
6.69 &nbsp;-&gt; 6.70<br />
6.60 &nbsp;-&gt; 6.60<br />
6.58 &nbsp;-&gt; 6.60
</div>


<div>
Hi angellll<br />
<br />
Just a question on your expression, why * 20 and divde by 20.00 ?
</div>


<div>
By definition:<br />
MROUND = ROUND(Number / Multiple, 0) * Multiple 
</div>


<div>
<div class="content wysiwyg-content">
Hello SQL &nbsp;Experts<br />
How to round up nearest 0.05 when it passes 0.25 base point and round down to nearest 2 decimal places in SQL?<br />
<br />
6.730 - &gt;&nbsp; 6.75<br />
6.623 &nbsp;-&gt; &nbsp;6.60<br />
Tks
</div>
</div>


Hello SQL  Experts
How to round up nearest 0.05 when it passes 0.25 base point and round down to nearest 2 decimal places in SQL?

6.730 - >  6.75
6.623  ->  6.60
Tks

How to round up nearest 0.05 when it passes 0.25 base point and round down to nearest 2 decimal places in SQL?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.