title: include missing columns
body: <p>I have a table called tenancy with a PK account period and amount</p>
  
  <pre><code>TenancyPK     Accountperiod     Amount
  48738562851   2018/04           1458
  48738562851   2018/08           45
  </code></pre>
  
  <p>Im using this code to make all the accounting periods </p>
  
  <pre><code>DECLARE @StartDate  DATETIME,
      @EndDate    DATETIME
  
  SELECT   @StartDate = '20110501'        
      ,@EndDate   = '20110801'
  
  
  SELECT  DATENAME(MONTH, DATEADD(MONTH, x.number, @StartDate)) AS MonthName
  FROM    master.dbo.spt_values x
  WHERE   x.type = 'P'        
  AND     x.number &lt;= DATEDIFF(MONTH, @StartDate, @EndDate)
  </code></pre>
  
  <p>i want to see </p>
  
  <pre><code>TenancyPK     Accountperiod     Amount
  48738562851   2018/04           1458
  48738562851   2018/05           0
  48738562851   2018/06           0
  48738562851   2018/07           0
  48738562851   2018/08           45
  </code></pre>