Paste this into a new question or an answer at dba.stackexchange.com:
<!-- --> > SELECT CONVERT(NUMERIC(19,2), CONVERT(FLOAT, 9.76499999999999999999999999)) AS Truncated; > GO > > <pre> > | Truncated | > | :-------- | > | 9.76 | > </pre> <!-- --> > SELECT CONVERT(NUMERIC(19,2), CONVERT(FLOAT, 9.7649999999999999999999)) AS Rounded; > GO > > <pre> > | Rounded | > | :------ | > | 9.77 | > </pre> *db<>fiddle [here](https://dbfiddle.uk/?rdbms=sqlserver_2014&fiddle=8f9376dd165d3d2da83114bdb7a19cb3)*
back to fiddle