title: For each day between two dates, add a row with the same info but only that day in the start/end columns
body: <p>I have a table, with types <code>varchar</code>, <code>datetime</code>, <code>datetime</code>:</p>
  
  <pre class="lang-none prettyprint-override"><code>NAME | START | END
  Bob  | 10/30 | 11/2
  </code></pre>
  
  <p>What's a SQL query can I look up to find out how to make that table be?:</p>
  
  <pre class="lang-none prettyprint-override"><code>NAME | START | END
  Bob  | 10/30 | 10/30
  Bob  | 10/31 | 10/31
  Bob  | 11/01 | 11/01
  Bob  | 11/02 | 11/02
  </code></pre>
  
  <p>This is only ran once, and on a very small dataset.  Optimization isn't necessary.</p>