Feb-07-2020, 03:44 PM
Hi,
I have a requirement of creating consecutive rows. My data has ID#, start dt and end date. For example:
I want to create rows like
Data is very huge and there are various dates. If there is overlapping I find from different row for same ID for example 08 2010, i want to keep it only once.
Pls advise.
I have a requirement of creating consecutive rows. My data has ID#, start dt and end date. For example:
Quote:ID start date end date
11 07-01-2010 10-01-2010
I want to create rows like
Quote:ID MM YY
11 07 2010
11 08 2010
11 09 2010
11 10 2010
Data is very huge and there are various dates. If there is overlapping I find from different row for same ID for example 08 2010, i want to keep it only once.
Pls advise.