Home Forums SQL Server 2005 SQL Server 2005 General Discussion Converting Null Sum to zero in MS SQL Server 2005 RE: Converting Null Sum to zero in MS SQL Server 2005
SGT_squeequal
SSCertifiable
Points: 7167
More actions
July 10, 2012 at 3:42 am
#1510767
looks like i stand corrected and you cant use SET CONCAT_NULL_YIELDS_NULL { ON | OFF } for calculations of int field so use isnull function 🙂
***The first step is always the hardest *******