For example,
Table A:
| FromDate | ToDate |
| ———-| ———–|
| 2024-04-01| 2024-04-03 |

Expected results:
| Date |
| ————- |
| 2024-04-01 |
| 2024-04-02 |
| 2024-04-03 |

I have seen different posts on stackoverflow but all of them are using CTE.
May I know if there is any method to do this other than using CTE?