title: Exclude multiple sum rows when all zero
body: <p>I would like to exclude a row in the query result if all 3 sum columns are zero.</p>
  
  <pre><code>Select Name
  ,sum(case when cast(Date as date) &lt;= Convert(datetime, '2014-05-01') then 1 else 0 end) as 'First'
  ,sum(case when cast(Date as date) &lt;= Convert(datetime, '2014-04-01') then 1 else 0 end) as 'Second'
  ,sum(case when cast(Date as date) &lt;= Convert(datetime, '2013-05-01') then 1 else 0 end) as 'Third'
  FROM [dbo].[Posting]
  inner join dbo.Names on Name.NameId = Posting.NameId
  where active = 1 
  group by Name
  order by Name
  </code></pre>