title: Query for how to add the missing dates in sql
body: <p>need to know how to add the date missing with null data in the corresponding field </p>
  
  <pre><code>**05/28/2012    NULL
  05/29/2012  NULL
  05/30/2012  NULL
  05/30/2012  Break In
  05/30/2012  Break Out
  05/31/2012  NULL**
  
  06/03/2012  NULL
  06/03/2012  Break In
  06/03/2012  Break Out
  06/03/2012  In Duty
  06/03/2012  Out Duty
  06/04/2012  NULL
  06/04/2012  In Duty
  06/04/2012  Out Duty
  06/05/2012  NULL
  06/05/2012  Break In
  06/05/2012  Break Out
  06/06/2012  NULL
  06/06/2012  Break In
  06/06/2012  Break Out
  06/06/2012  In Duty
  06/06/2012  Out Duty
  06/07/2012  NULL
  06/07/2012  In Duty
  06/07/2012  Out Duty
  
  06/10/2012  NULL
  06/10/2012  Break Out
  06/10/2012  In Duty
  06/10/2012  Out Duty
  06/11/2012  NULL
  06/11/2012  In Duty
  06/11/2012  Out Duty
  06/12/2012  NULL
  06/13/2012  NULL
  06/14/2012  NULL
  </code></pre>
  
  <p>The result that I need is like:</p>
  
  <pre><code>05/28/2012  NULL
  05/29/2012  NULL
  05/30/2012  NULL
  05/30/2012  Break In
  05/30/2012  Break Out
  05/31/2012  NULL
  06/01/2012      null
  06/02/2012      null
  06/03/2012  NULL
  06/03/2012  Break In
  06/03/2012  Break Out
  06/03/2012  In Duty
  06/03/2012  Out Duty
  06/04/2012  NULL
  06/04/2012  In Duty
  06/04/2012  Out Duty
  06/05/2012  NULL
  06/05/2012  Break In
  06/05/2012  Break Out
  06/06/2012  NULL
  06/06/2012  Break In
  06/06/2012  Break Out
  06/06/2012  In Duty
  06/06/2012  Out Duty
  06/07/2012  NULL
  06/07/2012  In Duty
  06/07/2012  Out Duty
  06/08/2012      null
  06/09/2012      null
  06/10/2012  NULL
  06/10/2012  Break Out
  06/10/2012  In Duty
  06/10/2012  Out Duty
  06/11/2012  NULL
  06/11/2012  In Duty
  06/11/2012  Out Duty
  06/12/2012  NULL
  06/13/2012  NULL
  06/14/2012  NULL
  </code></pre>