transpose data from columns to row & inserting date in between 2 dates

[michaelmedaflor]

Current format:  

Table1

VacStartDate	VacEndDate	Emp
28/01/2018	02/02/2018	140115
23/01/2018	24/01/2018	140009

Please if you can help me convert  when loading:

I need something like this

Date	Emp
28/01/2018	140115
29/01/2019	140115
30/01/2020	140115
30/01/2021	140115
31/01/2022	140115
01/02/2023	140115
02/02/2024	140115
23/01/2018	140009
24/01/2018	140009

Thanks a lot,

Mike

[sunny_talwar]

Check my response here

Re: Start and End Date Conversion