Iteration between dates

[JCV]

Hi,

For make a Calendar, I've a tasks table with two fields datetime, DateBegin and a DateEnd:

TaskID int
DateBegin datetime
DateEnd datetime

1001 01/01/2008 01/15/2008
1002 01/03/2008 01/10/2008
1003 01/04/2008 01/25/2008
...

I need obtain a select who return for each tasks all dates between the begin date and the end date whithout use a cursor.

Same as :

TaskID Date
1001 01/01/2008
1001 01/02/2008
...
1001 01/15/2008
1002 01/03/2008
1002 01/04/2008
...
1002 01/10/2008

Thanks.

 

[r937]

see Generating date ranges in the article Why should I consider using an auxiliary numbers table?

r937.com | rudy.ca