title: SQL Server - NULL value in calculation results in NULL Result
body: <p>I've got this issue that I'm sure everyone else who's worked with MSSQL has dealt with:</p>
  
  <pre><code>CREATE TABLE #temp (
      value1 DECIMAL(10,2)
      , value2 DECIMAL(10,2)
  );
  
  INSERT INTO #temp VALUES (1.00, NULL); 
  
  SELECT value1 + value2 FROM #temp
  </code></pre>
  
  <p>If I run the last <code>value1 + value2</code> query, rather than getting the expected result (<code>1.00</code>), it returns <code>NULL</code> when one of the values I'm including in the calculation is <code>NULL</code>. This is causing all kinds of grief in my reports because the query isn't returning the right value when one of my inputs is <code>NULL</code>.</p>
  
  <p>Is there a workaround for the above to get the expected <code>1.00</code> result instead of <code>NULL</code>, such that the <code>NULL</code> second value is treated as zero? </p>