armaandani (1/18/2013)

---

thanks for your rply.
Actually i am working in visual studion 2010 and SQL Express server 2008. i created my database through SQL Express server 2008.
Now i have i have a table in which i have three coulmns.
StartDate EndDate Class
and i have an another table name as "DateTabe" which has also three coulmns
Date Class Time

i want that the date selected between StartDate and EndDate is made available in 'Date' coulmn which is in DateTable with class in 'class' coulmn.

StartDate EndDate class
10/1/12 13/1/12 A
14/1/12 17/1/12 B

Then these can be show as in DateTable as

Date class Time
10/1/12 A
11/1/12 A
12/1/12 A
13/1/12 A
14/1/12 B
15/1/12 B
16/1/12 B
17/1/12 B

Please explain in such way so that i can implement it in visual studio 2010.

Thanks in advance