I read all rounding functions of T-SQL like Round,Floor,Ceil ... 1) select CAST( FLOOR(2 * 3.69) / 2 AS ...
stackoverflow.com