thanks for your rply

after excuting this query i got all the table of T1.

Actually i have two table T1.

in T1 i have two coulmns StartData and EndDate.

i want the date range selected between StartData and EndDate is to available in Date coulmn in another table.

As there are many rows in T1 so each row has to have its own StartData and EndDate. So for each row i want different table to be created. As there any way to implement it.

thanks in advance.