Re: How can a group by clause be modified so the end weeks of the year won't be split?
Date: Thu, 29 Jan 2009 03:10:21 -0800 (PST)
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
Philipp PostReceived on Thu Jan 29 2009 - 12:10:21 CET