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