Gopinath Srirangan (8/27/2010)
Hi,But another sample query as shown below gives expected result which contradicts from while loop.
DECLARE @i float
set @i = .9
set @i = @i + .1
You're only adding one float there, so the cumulative error isn't that great. In the original WHILE loop there were ten separate additions of 0.1, which caused more of an issue.