Avg of float inconsistency
This is very similiar to: SELECT SUM(…) is non-deterministic when adding the column-values of datatype float. The problem is that with inaccurate datatype (FLOAT/REAL) the order of of arithmetic operations on floating point matters. Demo from connect: DECLARE @fl FLOAT = 100000000000000000000 DECLARE @i SMALLINT = 0 WHILE (@i < 100) BEGIN SET @fl = … Read more