Sorry, Maybe I was unclear.
I don't need to duplicate this data but I need to list all calendar dates between the StartDate & the EndDate.
For example: StartDate is 05/03/2019 & EndDate is 09/03/2019
-> The result should be:
05/03/2019
06/03/2019
07/03/2019
08/03/2019
09/03/2019
Hi everyone,
I'm new here and I'm in need for your expertise.
I have a table called "tbl.DateRange" with the following data:
Number StartDate EndDate
1 05/03/2019 08/03/2019
2 25/02/2019 27/02/2019
I need all dates between the StartDate & EndDate...