Weekly Breakdown

[Benny]

I might be overcomplicatin g 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 )]

Re: Weekly Breakdown

On Apr 16, 11:40 am, Benny <bennyandli...@ gmail.comwrote:

I might be overcomplicatin g 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