Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have an original table
cod, quantity, date_start, date_end
DE2520, 10 , 01-01-2020, 31-10-2020
and this is the final table I need to have. generating row depending on how much month there is between start date and end date
cod, quantity, month, year
DE2520, 1 , 1,2020,
DE2520, 1 , 2,2020,
DE2520, 1 , 3,2020,
DE2520, 1, 4,2020,
DE2520, 1 , 5,2020,
DE2520, 1 , 6,2020,
DE2520, 1, 7,2020,
DE2520,1, 8,2020,
DE2520,1, 9,2020,
DE2520,1 , 10,2020
thanks
FYI,
FYI,
Thanks Prashant great.
This is what I needed
Enrico