Home Forums Article Discussions Article Discussions by Author Discuss content posted by Carlo Romagnano SET ROWCOUNT and table variable RE: SET ROWCOUNT and table variable

  • August 27, 2010 at 4:37 am

    #1212839

    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.