Hi All
DECLARE@count NUMERIC(8, 2) set @count = 165.165 print @count
Result is giving '165.17' where as i need '165.16'
it should not round of the number
please help
Answer by Kev Riley · Jan 21 at 01:06 PM
You need to explicitly truncate the number using the 3rd argument in the ROUND() function
declare @count NUMERIC(8, 2) set @count = round(165.165,2,1) print @count 165.16
https://docs.microsoft.com/en-us/sql/t-sql/functions/round-transact-sql