Weekly Breakdown

[Benny]

I might be overcomplicating the solution, but the problem is I have to
make a breakdown of each week for many ranges of dates within a
particular year. So for example one record might have a start date of
1/1/2008 and an end date of 2/31/2008 and I need to break down each
week within that period and display the data corresponding to that
range. Here is an example of the data and how it should look.

StartDate EndDate DataToDisplay
-------------- ------------- ----------------------
1/1/2008 2/28/2008 Hello Mess!
3/1/2008 3/15/2008 Some Data
12/15/2008 1/15/2009 Curveball

Jan Feb ....
Dec
Week 1 | Hello Mess! Hello Mess! ....
Week 2 | Hello Mess! Hello Mess! ....
Week 3 | Hello Mess! .... Curveball
Week 4 | Hello Mess! .... Curveball
Week 5 | Hello Mess! .... Curveball

Any ideas?

[Ignacio Machin ( .NET/ C# MVP )]

On Apr 16, 11:40*am, Benny <[e-mail]:

I might be overcomplicating the solution, but the problem is I have to
make a breakdown of each week for many ranges of dates within a
particular year. *So for example one record might have a start date of
1/1/2008 and an end date of 2/31/2008 and I need to break down each
week within that period and display the data corresponding to that
range. *Here is an example of the data and how it should look.

StartDate * * * * *EndDate * * * DataToDisplay
-------------- * * * * *------------- * * *----------------------
1/1/2008 * * * * * 2/28/2008 * * Hello Mess!
3/1/2008 * * * * * 3/15/2008 * * Some Data
12/15/2008 * * * 1/15/2009 * * *Curveball

* * * * * * * * * Jan * * * * * * * * Feb * * * * * * ....
Dec
Week 1 | *Hello Mess! * *Hello Mess! * * * * * * * ** *....
Week 2 | *Hello Mess! * *Hello Mess! * * * * * * * ** *....
Week 3 | *Hello Mess! * * * * .... * * * * * * * * * * * Curveball
Week 4 | *Hello Mess! * * * * .... * * * * * * * * * * * Curveball
Week 5 | *Hello Mess! * * * * .... * * * * * * * * * * * Curveball

Any ideas?

Hi,

Where is that data stored?
Is this in SQL?

you need to give more details, also if this is an SQL question post it
in the correct rgoup