The mysteries of SUM()

Question

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Nils Gustav Stråbø SSChampion Points: 11259 More actions · Answer 1

That is because float is an approximate-valued data type, unlike the decimal data type.

For example, the value of @a in this T-SQL script will never be 1.

declare @a float, @b-2 float

set @a=0

while @a<>1

begin

print @a

set @a=@a+0.1

end

evald SSCrazy Points: 2165 More actions · Answer 2

:w00t:

Thank you,

i never thought the float type could be the issue.