DSXchange

Hi,

I will need to splitup the dates as there are overlapping

Type Start Stop
---------------------------------------------
C 01/01/2011 01/31/2011

B 02/01/2011 05/31/2011
C 03/01/2011 08/31/2011
D 05/01/2011 10/31/2011
B 09/01/2011 12/31/2011


Since there are overlaps, the timeline needs to be split as follows:

Start Stop active
---------------------------------------------
01/01/2011 01/31/2011 C only
02/01/2011 02/28/2011 B only
03/01/2011 04/30/2011 B, C
05/01/2011 05/31/2011 B, D, C
06/01/2011 08/31/2011 C, D
09/01/2011 10/31/2011 B, D
11/01/2011 12/31/2011 B only


kindly let me know your thoughts.

Thanks,
Satheesh.R

Have you analysed your logic and written out an algorithm? What have you already tried?

Or are you just expecting us to do your work for you?