title: How to Show Zero Count in SQL SERVER Query
body: <p>I want to know that how we can display ZERO count? I have only one table and I am doing monthly count but some how 1 month doesn't have any rows and SQL Server is skipping that month during count but I need to show in my report.</p>
  
  <p>This is my query that I am using:</p>
  
  <pre><code>SELECT 
      MONTH(createdDate) [Month], 
      ISNULL(COUNT(id), 0) [Count]
  FROM 
      [PocketLife].[dbo].[Notifications]
  WHERE 
      description = 'Welcome to Pocket Link' AND 
      YEAR(CAST(createdDate as DATE)) = YEAR(GETDATE())
  GROUP BY 
      MONTH(createdDate)
  </code></pre>
  
  <p>Currently the above query is showing like this but it is missing the First Month Record which is ZERO.</p>
  
  <pre><code>Month   Count
  --------------
  2            5 
  3          295 
  4         8295 
  5       149855 
  6       447752 
  7         6311 
  </code></pre>
  
  <p>But it should Show as below and this is the actual Result:</p>
  
  <pre><code>Month   Count
  --------------
  1            0 
  2            5 
  3          295 
  4         8295 
  5       149855 
  6       447752 
  7         6311 
  </code></pre>
  
  <p>Any help will be appreciated.</p>