title: identify missing rows SQL Server 2008 R2
body: <p><a href="https://i.stack.imgur.com/mpNN1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mpNN1.png" alt="enter image description here"></a></p>
  
  <p>I have a table with four columns:  MeterName, TenantLease, BuildingID, and Date (last day of month).  Each row is unique when looking at all four columns together.  </p>
  
  <p>Issue:<br>
  If there is not an entry for a month(s) between 11-30-2016 to 10-31-2017 THEN my query result should identify <strong><em>Missing</em></strong> date entries for each MeterName, TenantLease, and BuildingID.</p>
  
  <p>Example1:
  For Meter1, Tenant1, bld1, I expect to return 9/30/2017 and 10/31/2017 (along with all columns - MeterName, TenantLease, and Buildingid) because those are the missing entries.</p>
  
  <p>Example2:
  For Meter2, Tenant1, bld1, I expect to return 11/30/2016, 12/31/2016, 4/30/2017, 8/31/2016, 9/30/2017 and 10/31/2017  (along with all columns - MeterName, TenantLease, and Buildingid) because those are the missing entries.</p>
  
  <p>I tried full join, cross apply, outer apply, and etc. However, none would return data that I require.</p>