http://blogs.msdn.com/b/psssql/archive/2010/11/01/how-it-works-sql-paring-of-number-s-numeric-and-float-conversions.aspx&#160;&#160;&#160;&#160;&#160;&#160;&#160; SQL Server and other documentation have always indicated that float values are not precise and comparison or conversion of them can be problematic and imprecise.&#160;&#160; Working on a recent customer caseen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/psssql/archive/2010/11/01/how-it-works-sql-paring-of-number-s-numeric-and-float-conversions.aspx#10085861Thu, 04 Nov 2010 03:02:37 GMT91d46819-8472-40ad-a661-2c78acb4018c:10085861Boyan Penev<p>Nice post. I have had issues with float comparisons once they get into SSIS. It can make debugging very annoying, partially because SSMS actually shows rounded values. It would be good if there can be a switch somewhere in SSMS to change this default behavior.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10085861" width="1" height="1">http://blogs.msdn.com/b/psssql/archive/2010/11/01/how-it-works-sql-paring-of-number-s-numeric-and-float-conversions.aspx#10085369Wed, 03 Nov 2010 12:04:06 GMT91d46819-8472-40ad-a661-2c78acb4018c:10085369Holger Schmeling<p>Interesting stuff! I discovered a similiar problem with SQL Server aggregate functions a while ago.</p> <p>You may won to check connect item 465147. See here</p> <p><a rel="nofollow" target="_new" href="https://connect.microsoft.com/SQLServer/feedback/details/465147/select-sum-is-non-deterministic-when-adding-the-column-values-of-datatype-float">connect.microsoft.com/.../select-sum-is-non-deterministic-when-adding-the-column-values-of-datatype-float</a></p> <p>Regards,</p> <p>Holger</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10085369" width="1" height="1">