<div>
Just to clarify, the problem is that if the first select returns NULL and the second returns 500<br />
the result is still NULL
</div>


Just to clarify, the problem is that if the first select returns NULL and the second returns 500
the result is still NULL

<div>
select SUM(COALESCE(fldAmount, 0)) FROM tblPaymentOut WHERE fldContactRef = @ContactRef<br />
<br />
Is still returning NULL
</div>


select SUM(COALESCE(fldAmount, 0)) FROM tblPaymentOut WHERE fldContactRef = @ContactRef

Is still returning NULL

<div>
Small Change in mathewspatrick's comment:<br />

<pre><code id="code-368698">SELECT (SELECT SUM(COALESCE(fld1,0)) FROM tbl1) 
+ (SELECT SUM(COALESCE(fld1,0)) FROM tbl2) as sum_total
</code></pre>
</div>


Small Change in mathewspatrick's comment:


SELECT (SELECT SUM(COALESCE(fld1,0)) FROM tbl1) 
+ (SELECT SUM(COALESCE(fld1,0)) FROM tbl2) as sum_total


<div>
<div class="content wysiwyg-content">
Here is my problem. &nbsp;<br />
<br />
I have a query like: SELECT (SELECT SUM (fld1) FROM tbl1 + SELECT SUM9fld1 FROM tbl2)<br />
<br />
This works fine, except when 1 (or both) of the SELECT SUM statements returns NULL. &nbsp;How can I make it return a 0 instead of a NULL so it doesnt mess up my calculation?<br />
<br />
Thanks
</div>
</div>


Here is my problem.  

I have a query like: SELECT (SELECT SUM (fld1) FROM tbl1 + SELECT SUM9fld1 FROM tbl2)

This works fine, except when 1 (or both) of the SELECT SUM statements returns NULL.  How can I make it return a 0 instead of a NULL so it doesnt mess up my calculation?

Thanks

SQL - Adding two select statements, handling NULL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.