May 11, 2009 at 9:13 am
i would like to get the report like marh to april weekly wise, SO i need to get the weeks seperation from 1st of march to 31 april. can any one have sample snippets. It's urgent.
May 11, 2009 at 2:12 pm
I'm going to ask some questions to clarify the problem. All of the questions would be answered if you had posted the question using th emethod suggested in the top link in my signature.
What is your table structure?
Do you want data something like this?
Month Week Sales
------ ---- -----
March 1 1200
March 2 900
March 3 1000
March 4 850
What day do you want the week to start on?
How do you want to handle it if the month starts/ends mid-week? Is that considered a full week?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 11, 2009 at 2:30 pm
Please don't cross post!
I'd recommend to continue the thread on http://www.sqlservercentral.com/Forums/FindPost713955.aspx
since it contains more input from the OP so far...
May 11, 2009 at 2:36 pm
Thanks for posting the link Lutz. Looks like I only wasted a little time on this thread.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 12, 2009 at 1:29 am
I want the report like this.
program name Jan(01/01-01/07) jan(01/08-01/14)......may(05/25-05/31)
XXXXXX 78 54................. 23
YYYYYY 12 45................. 33
Where i struck is how do we consider the week. For example(what I have taken was 7 days considered as one week. In this case if some days left in a month, after considering 7 days as a week, in which month we have to put remaining days. (Let’s take an example if we take a January month, 4 weeks and 3 days are present. So In January 3 days are left, these three days in which month do we need to take, either January or February). If we considered the left days into January month, for the month of May I am getting 5 weeks. After that weeks and months were misplacing.
Can you please let me know how do I proceed regarding the same?
May 12, 2009 at 1:32 am
week can be considered SUN-SAT. Please let me know if you need any more details
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply