Re: How can a group by clause be modified so the end weeks of the year won't be split?

From: Philipp Post <Post.Philipp_at_googlemail.com>
Date: Thu, 29 Jan 2009 03:10:21 -0800 (PST)
Message-ID: <c7cd1b6a-c3b6-4223-8ef7-ad6fd124ecfb_at_v5g2000pre.googlegroups.com>

Ted,

> The ONLY problem, here, is that if New Years day occurs in the middle of the week, that week's data will be split at the first second of the New Year. �<

A nobody said it yet: a calendar table often might help in such a situation. A web search brings up some samples how to construct that. Basically you create a table holding all date values in which your busineess might occurr. Then you add columns for the week number and whatever you else may need. Then a simple JOIN operation on the date columns helps to get the desired week number out of the calendar table.

Philipp Post Received on Thu Jan 29 2009 - 12:10:21 CET

This message: [ Message body ]
Next message: imbiz40_at_gmail.com: "Earn Online, Want to know how?"
Previous message: Auno Saari: "Re: Ankeriaspornoa"
In reply to: Ted Byers: "How can a group by clause be modified so the end weeks of the year won't be split?"
In reply to Ted Byers: "How can a group by clause be modified so the end weeks of the year won't be split?"
Next in thread: Bob Badour: "Re: How can a group by clause be modified so the end weeks of the year won't be split?"
Reply: Bob Badour: "Re: How can a group by clause be modified so the end weeks of the year won't be split?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message