Any Date range within a week where the week start is monday and weekend is monday.
No Name FromDate Tilldate
1 ABCD 25-5-2010 25-5-2010
2 DSFA 22-6-2010 23-6-2010
3 WERQ 13-8-2010 19-8-2010

From above table, use T-SQL to split the above date range and
create a row for each date within the range like below

No Name Date
1 ABCD 25-5-2010
2 DSFA 22-6-2010
2 DSFA 23-6-2010
3 WERQ 13-8-2010
3 WERQ 14-8-2010
3 WERQ 15-8-2010
3 WERQ 16-8-2010
3 WERQ 17-8-2010
3 WERQ 18-8-2010
3 WERQ 19-8-2010