<div>
If you mean to show the sum if non-zero, and nothing if the sum is zero...<br />
<br />
<br />

<pre><code id="code-20-37028002-1">SELECT ID, CASE WHEN SUM(OtherColumn) &lt;&gt; 0 THEN SUM(OtherColumn) ELSE NULL END AS Result
FROM SomeTable
GROUP BY ID</code></pre>
</div>


If you mean to show the sum if non-zero, and nothing if the sum is zero...




SELECT ID, CASE WHEN SUM(OtherColumn) <> 0 THEN SUM(OtherColumn) ELSE NULL END AS Result
FROM SomeTable
GROUP BY ID

<div>
Um...yeah, you rock! &nbsp;Thanks!
</div>


<div>
You're welcome, happy coding :)
</div>


<div>
<div class="content wysiwyg-content">
How do I sum up the value of a given column for the rows that meet my query criteria, then return just the primary key of that column when that sum equals zero?
</div>
</div>


How do I sum up the value of a given column for the rows that meet my query criteria, then return just the primary key of that column when that sum equals zero?

SQL Query Help with SUM

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.