populate custom missing months

[#1]

Hi,

I have data in the foll. format:

aa2:

Load * INLINE

[ ObjID, StartDate, EndDate

OB1, '2012-04-01', '2012-07-25'

OB2, '2011-12-10', '2012-03-15'

OB3, '2012-06-20', '2012-06-25'

OB4, '2012-10-01', '2013-01-01'

];

Required:

OB1, 'APR-2012'

OB1, 'MAY-2012'

OB1, 'JUN-2012'

OB1, 'JUL-2012'

OB2, 'DEC-2011'

OB2, 'JAN-2012'

OB2, 'FEB-2012'

OB2, 'MAR-2012'

OB3, 'JUN-2012'

OB4, OCT-2012'

OB4, 'NOV-2012'

OB4, 'DEC-2012'

OB4, 'JAN-2012'

I need to generate missing months between start date and end date.  Also, the generated months will be different for each of the records as month generation depends on the Start date and end date.

Can anybody please suggest as to how should I proceed to resolve this issue?

Thanks.