title: SQL: Getting Missing Date Values and Copy Data to Those New Dates
body: <p>So this seems somewhat weird, but this use case came up, and I have been somewhat struggling trying to figure out how to come about a solution. Let's say I have this data set:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>date</th>
  <th>value1</th>
  <th>value2</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>2020-01-01</td>
  <td>50</td>
  <td>2</td>
  </tr>
  <tr>
  <td>2020-01-04</td>
  <td>23</td>
  <td>5</td>
  </tr>
  <tr>
  <td>2020-01-07</td>
  <td>14</td>
  <td>8</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>My goal is to try and fill in the gap between the two dates while copying whatever values were from the date before it. So for example, the data output I would want is:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>date</th>
  <th>value1</th>
  <th>value2</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>2020-01-01</td>
  <td>50</td>
  <td>2</td>
  </tr>
  <tr>
  <td>2020-01-02</td>
  <td>50</td>
  <td>2</td>
  </tr>
  <tr>
  <td>2020-01-03</td>
  <td>50</td>
  <td>2</td>
  </tr>
  <tr>
  <td>2020-01-04</td>
  <td>23</td>
  <td>5</td>
  </tr>
  <tr>
  <td>2020-01-05</td>
  <td>23</td>
  <td>5</td>
  </tr>
  <tr>
  <td>2020-01-06</td>
  <td>23</td>
  <td>5</td>
  </tr>
  <tr>
  <td>2020-01-07</td>
  <td>14</td>
  <td>8</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Not sure if this is something I can do with SQL but would definitely take any suggestions.</p>