CODEWITHSUNDEEP
sqlsql-serversql-server-2005rounding
alexcctan
alexcctan

Reputation: 123

SQL rounding mechanism

I have a following issue with rounding.

SQL Server 2005

SELECT ROUND(82.05,1) AS [Round Amount]

Result
[82.10]

SELECT ROUND(82.07,1) AS [Round Amount]
Result
[82.10]

How do I customize the rounding function as the below pic?

enter image description here

Upvotes: 1

Views: 132

Answers (1)

Leon Bambrick
Leon Bambrick

Reputation: 26306

SELECT ROUND(82.01*2,1)/2 AS [Round Amount]
82.00
SELECT ROUND(82.02*2,1)/2 AS [Round Amount]
82.00
SELECT ROUND(82.03*2,1)/2 AS [Round Amount]
82.05
SELECT ROUND(82.04*2,1)/2 AS [Round Amount]
82.05
SELECT ROUND(82.05*2,1)/2 AS [Round Amount]
82.05
SELECT ROUND(82.06*2,1)/2 AS [Round Amount]
82.05
SELECT ROUND(82.07*2,1)/2 AS [Round Amount]
82.05
SELECT ROUND(82.08*2,1)/2 AS [Round Amount]
82.10
SELECT ROUND(82.09*2,1)/2 AS [Round Amount]
82.10

Upvotes: 1

Related Questions