By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,175 Members | 1,689 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,175 IT Pros & Developers. It's quick & easy.

Weekly Breakdown

P: n/a
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?
Jun 27 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Apr 16, 11:40*am, Benny <bennyandli...@gmail.comwrote:
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
Jun 27 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.