title: How can I expand a table with a range between two dates as a new column in SQL Server?
body: <p>I have this table for example:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Start date</th>
  <th>End date</th>
  <th>value</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>2022-01-01</td>
  <td>2022-01-03</td>
  <td>value1</td>
  </tr>
  <tr>
  <td>2022-01-02</td>
  <td>2022-01-04</td>
  <td>value2</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>The output I want would be this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Start date</th>
  <th>End date</th>
  <th>value</th>
  <th>Date between</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>2022-01-01</td>
  <td>2022-01-03</td>
  <td>value1</td>
  <td>2022-01-01</td>
  </tr>
  <tr>
  <td>2022-01-01</td>
  <td>2022-01-03</td>
  <td>value1</td>
  <td>2022-01-02</td>
  </tr>
  <tr>
  <td>2022-01-01</td>
  <td>2022-01-03</td>
  <td>value1</td>
  <td>2022-01-03</td>
  </tr>
  <tr>
  <td>2022-01-02</td>
  <td>2022-01-04</td>
  <td>value2</td>
  <td>2022-01-02</td>
  </tr>
  <tr>
  <td>2022-01-02</td>
  <td>2022-01-04</td>
  <td>value2</td>
  <td>2022-01-03</td>
  </tr>
  <tr>
  <td>2022-01-02</td>
  <td>2022-01-04</td>
  <td>value2</td>
  <td>2022-01-04</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Thank you in advance!</p>