currently the data is inserted as

frmdate todate

2009-12-14 2009-12-28

2010-01-14 2010-01-28

2010-02-14 2010-02-28

instead of

frmdate todate

2009-12-14 2009-12-28

2009-12-29 2010-01-13

2010-01-14 2010-01-28

2010-01-29 2010-02-13

2010-02-14 2010-02-28

2010-03-01 2010-03-13

so used cross apply

its working fine

but with a issue in other fields which were taken i query