title: SQL Server + returning null data
body: <p>Hi I have a query like this which returns enrollment data for the past 6 months, however data will only be display should there be at least 1 enrollment, how can display the months which have no enrollment as well? I know I probably have to do something to this line:</p>
  
  <pre><code>LEFT(CONVERT(varchar, issuedate, 112), 6) BETWEEN 
     LEFT(CONVERT(varchar, DATEADD(MM, -6, GETDATE()), 112), 6) AND 
     LEFT(CONVERT(varchar, GETDATE(), 112), 6)
  </code></pre>
  
  <p>Thanks.</p>
  
  <pre><code>SELECT 
      DateName(month,issuedate) + ' ' + CAST(Year(issuedate) as Char(4)) as IssueDate,
      COUNT(distinct m.ID) AS SignUps
  FROM
      Member m 
  INNER JOIN 
      Card c ON m.ID = c.MemberID
  WHERE 
      m.Deletedby is null 
      AND c.Deletedby is null
      AND LEFT(CONVERT(varchar, issuedate, 112), 6) BETWEEN   
              LEFT(CONVERT(varchar, DATEADD(MM, -6, GETDATE()), 112), 6) 
              AND LEFT(CONVERT(varchar, GETDATE(), 112), 6)
   GROUP BY 
      DateName(month, issuedate) + ' ' + CAST(Year(issuedate) AS  Char(4)), CAST(CAST(YEAR(issuedate) AS VARCHAR) + '/'+ CAST(MONTH(issuedate) AS VARCHAR) +'/1' AS DateTime)
  </code></pre>