DB Puzzle

[rnjnagu]

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

[szlamany]

Can you create a table with all dates in it? That is the obvious and easiest way to deal with this.

If you cannot do that then can you use a stored procedure to do this?

Is this MS SQL server?

[rnjnagu]

Yes. It is MS SQL.. u just consider above is the table with date range.. Can u give me the solution for that?

[szlamany]

I would create another table with "all dates" in it and then join to that - simple join - but before I go to the effort of showing you a solution that involves another table.

Please answer my two other questions.

I did ask them - I would not have asked them if it didn't matter.

Why don't people answer questions put to them on the forum - it drives me totally insane!!