Here's some results on SQL Server 2000 starting with a value of -10 and
working my way up to 10 in .01 increments. Snipped for brevity.
The SQL:
set nocount on
drop table #temp
create table #temp (orig float(53), rounded float(53))
declare @num float(53)
SET @num = -10
WHILE @num < 10
BEGIN
INSERT INTO #temp VALUES(@num, ROUND(@num, 1))
SET @num = @num + .01
END
select * from #temp
The results:
orig
rounded
----------------------------------------------------- ------------------
-10.0 -10.0
-9.9900000000000002 -10.0
-9.9800000000000004 -10.0
-9.9700000000000006 -10.0
-9.9600000000000009 -10.0
-9.9500000000000011 -10.0
-9.9400000000000013 -9.9000000000000004
-9.9300000000000015 -9.9000000000000004
-9.9200000000000017 -9.9000000000000004
-9.9100000000000019 -9.9000000000000004
-9.9000000000000021 -9.9000000000000004
-9.8900000000000023 -9.9000000000000004
-9.8800000000000026 -9.9000000000000004
-9.8700000000000028 -9.9000000000000004
-9.860000000000003 -9.9000000000000004
-9.8500000000000032 -9.9000000000000004
-9.8400000000000034 -9.8000000000000007
-9.8300000000000036 -9.8000000000000007
-9.8200000000000038 -9.8000000000000007
-9.8100000000000041 -9.8000000000000007
-9.8000000000000043 -9.8000000000000007
-9.7900000000000045 -9.8000000000000007
-9.7800000000000047 -9.8000000000000007
-9.7700000000000049 -9.8000000000000007
-9.7600000000000051 -9.8000000000000007
-9.7500000000000053 -9.8000000000000007
-9.7400000000000055 -9.6999999999999993
-9.7300000000000058 -9.6999999999999993
-9.720000000000006 -9.6999999999999993
-9.7100000000000062 -9.6999999999999993
-9.7000000000000064 -9.6999999999999993
-9.6900000000000066 -9.6999999999999993
-9.6800000000000068 -9.6999999999999993
-9.670000000000007 -9.6999999999999993
-9.6600000000000072 -9.6999999999999993
-9.6500000000000075 -9.6999999999999993
-9.6400000000000077 -9.5999999999999996
-9.6300000000000079 -9.5999999999999996
-9.6200000000000081 -9.5999999999999996
-9.6100000000000083 -9.5999999999999996
-9.6000000000000085 -9.5999999999999996
-9.5900000000000087 -9.5999999999999996
-9.580000000000009 -9.5999999999999996
-9.5700000000000092 -9.5999999999999996
-9.5600000000000094 -9.5999999999999996
-9.5500000000000096 -9.5999999999999996
-9.5400000000000098 -9.5
-9.53000000000001 -9.5
-9.5200000000000102 -9.5
-9.5100000000000104 -9.5
-9.5000000000000107 -9.5
-9.4900000000000109 -9.5
-9.4800000000000111 -9.5
-9.4700000000000113 -9.5
-9.4600000000000115 -9.5
-9.4500000000000117 -9.5
-9.4400000000000119 -9.4000000000000004
-9.4300000000000122 -9.4000000000000004
-9.4200000000000124 -9.4000000000000004
-9.4100000000000126 -9.4000000000000004
-9.4000000000000128 -9.4000000000000004
-9.390000000000013 -9.4000000000000004
-9.3800000000000132 -9.4000000000000004
-9.3700000000000134 -9.4000000000000004
-9.3600000000000136 -9.4000000000000004
-9.3500000000000139 -9.4000000000000004
-9.3400000000000141 -9.3000000000000007
-9.3300000000000143 -9.3000000000000007
-9.3200000000000145 -9.3000000000000007
-9.3100000000000147 -9.3000000000000007
-9.3000000000000149 -9.3000000000000007
-9.2900000000000151 -9.3000000000000007
-9.2800000000000153 -9.3000000000000007
-9.2700000000000156 -9.3000000000000007
-9.2600000000000158 -9.3000000000000007
-9.250000000000016 -9.3000000000000007
-9.2400000000000162 -9.1999999999999993
-9.2300000000000164 -9.1999999999999993
-9.2200000000000166 -9.1999999999999993
-9.2100000000000168 -9.1999999999999993
-9.2000000000000171 -9.1999999999999993
-9.1900000000000173 -9.1999999999999993
-9.1800000000000175 -9.1999999999999993
-9.1700000000000177 -9.1999999999999993
-9.1600000000000179 -9.1999999999999993
-9.1500000000000181 -9.1999999999999993
-9.1400000000000183 -9.0999999999999996
-9.1300000000000185 -9.0999999999999996
-9.1200000000000188 -9.0999999999999996
-9.110000000000019 -9.0999999999999996
-9.1000000000000192 -9.0999999999999996
-9.0900000000000194 -9.0999999999999996
-9.0800000000000196 -9.0999999999999996
-9.0700000000000198 -9.0999999999999996
-9.06000000000002 -9.0999999999999996
-9.0500000000000203 -9.0999999999999996
-9.0400000000000205 -9.0
-9.0300000000000207 -9.0
-9.0200000000000209 -9.0
-9.0100000000000211 -9.0
-9.0000000000000213 -9.0
-8.9900000000000215 -9.0
[snip]
8.9999999999996838 9.0
9.0099999999996836 9.0
9.0199999999996834 9.0
9.0299999999996832 9.0
9.039999999999683 9.0
9.0499999999996827 9.0
9.0599999999996825 9.0999999999999996
9.0699999999996823 9.0999999999999996
9.0799999999996821 9.0999999999999996
9.0899999999996819 9.0999999999999996
9.0999999999996817 9.0999999999999996
9.1099999999996815 9.0999999999999996
9.1199999999996813 9.0999999999999996
9.129999999999681 9.0999999999999996
9.1399999999996808 9.0999999999999996
9.1499999999996806 9.0999999999999996
9.1599999999996804 9.1999999999999993
9.1699999999996802 9.1999999999999993
9.17999999999968 9.1999999999999993
9.1899999999996798 9.1999999999999993
9.1999999999996795 9.1999999999999993
9.2099999999996793 9.1999999999999993
9.2199999999996791 9.1999999999999993
9.2299999999996789 9.1999999999999993
9.2399999999996787 9.1999999999999993
9.2499999999996785 9.1999999999999993
9.2599999999996783 9.3000000000000007
9.2699999999996781 9.3000000000000007
9.2799999999996778 9.3000000000000007
9.2899999999996776 9.3000000000000007
9.2999999999996774 9.3000000000000007
9.3099999999996772 9.3000000000000007
9.319999999999677 9.3000000000000007
9.3299999999996768 9.3000000000000007
9.3399999999996766 9.3000000000000007
9.3499999999996763 9.3000000000000007
9.3599999999996761 9.4000000000000004
9.3699999999996759 9.4000000000000004
9.3799999999996757 9.4000000000000004
9.3899999999996755 9.4000000000000004
9.3999999999996753 9.4000000000000004
9.4099999999996751 9.4000000000000004
9.4199999999996749 9.4000000000000004
9.4299999999996746 9.4000000000000004
9.4399999999996744 9.4000000000000004
9.4499999999996742 9.4000000000000004
9.459999999999674 9.5
9.4699999999996738 9.5
9.4799999999996736 9.5
9.4899999999996734 9.5
9.4999999999996732 9.5
9.5099999999996729 9.5
9.5199999999996727 9.5
9.5299999999996725 9.5
9.5399999999996723 9.5
9.5499999999996721 9.5
9.5599999999996719 9.5999999999999996
9.5699999999996717 9.5999999999999996
9.5799999999996714 9.5999999999999996
9.5899999999996712 9.5999999999999996
9.599999999999671 9.5999999999999996
9.6099999999996708 9.5999999999999996
9.6199999999996706 9.5999999999999996
9.6299999999996704 9.5999999999999996
9.6399999999996702 9.5999999999999996
9.64999999999967 9.5999999999999996
9.6599999999996697 9.6999999999999993
9.6699999999996695 9.6999999999999993
9.6799999999996693 9.6999999999999993
9.6899999999996691 9.6999999999999993
9.6999999999996689 9.6999999999999993
9.7099999999996687 9.6999999999999993
9.7199999999996685 9.6999999999999993
9.7299999999996682 9.6999999999999993
9.739999999999668 9.6999999999999993
9.7499999999996678 9.6999999999999993
9.7599999999996676 9.8000000000000007
9.7699999999996674 9.8000000000000007
9.7799999999996672 9.8000000000000007
9.789999999999667 9.8000000000000007
9.7999999999996668 9.8000000000000007
9.8099999999996665 9.8000000000000007
9.8199999999996663 9.8000000000000007
9.8299999999996661 9.8000000000000007
9.8399999999996659 9.8000000000000007
9.8499999999996657 9.8000000000000007
9.8599999999996655 9.9000000000000004
9.8699999999996653 9.9000000000000004
9.8799999999996651 9.9000000000000004
9.8899999999996648 9.9000000000000004
9.8999999999996646 9.9000000000000004
9.9099999999996644 9.9000000000000004
9.9199999999996642 9.9000000000000004
9.929999999999664 9.9000000000000004
9.9399999999996638 9.9000000000000004
9.9499999999996636 9.9000000000000004
9.9599999999996633 10.0
9.9699999999996631 10.0
9.9799999999996629 10.0
9.9899999999996627 10.0
9.9999999999996625 10.0
