Here is a solution using the ROUND function:

with test_data_cte as

(

select datavalue

from

(

values

(5.0000016), -- should be 5.01

(6.1000138), -- should be 6.11

(7.1200073), -- should be 7.13

(5.0000000), -- should be 5.00

(6.1000000), -- should be 6.10

(7.1200000) -- should be 7.12

) dt (datavalue)

)

select

datavalue,

rounded_datavalue =

convert(numeric(8,2),round(datavalue+0.0049999,2))

from

test_data_cte

Results:

datavalue rounded_datavalue

--------------------------------------- -----------

5.0000016 5.01

6.1000138 6.11

7.1200073 7.13

5.0000000 5.00

6.1000000 6.10

7.1200000 7.12