Hi I have a table/query in Mysql like this :
ActivityId | ActivityName | Start | End |
1 | A |05-06-2010 | 10-09-2010 |
2 | B |01-09-2012 | 10-05-2013 |
I want to generate months and repeat other data between a start and end date. Like This
ActivityId | ActivityName | Start | End | Month |
1 | A |05-06-2010 | 10-09-2010 | 06-2010 |
1 | A |05-06-2010 | 10-09-2010 | 07-2010 |
1 | A |05-06-2010 | 10-09-2010 | 08-2010 |
1 | A |05-06-2010 | 10-09-2010 | 09-2010 |
2 | B |01-09-2012 | 10-05-2013 | 09-2012 |
2 | B |01-09-2012 | 10-05-2013 | 10-2012 |
2 | B |01-09-2012 | 10-05-2013 | 11-2012 |
2 | B |01-09-2012 | 10-05-2013 | 12-2012 |
2 | B |01-09-2012 | 10-05-2013 | 01-2013 |
2 | B |01-09-2012 | 10-05-2013 | 02-2013 |
2 | B |01-09-2012 | 10-05-2013 | 03-2013 |
2 | B |01-09-2012 | 10-05-2013 | 04-2013 |
2 | B |01-09-2012 | 10-05-2013 | 05-2013 |