How can a group by clause be modified so the end weeks of the year won't be split?
From: Ted Byers <r.ted.byers_at_gmail.com>
Date: Wed, 28 Jan 2009 12:10:34 -0800 (PST)
Message-ID: <783ee951-6678-4888-9628-0797d8207230_at_r34g2000vbp.googlegroups.com>
I have a SELECT statement similar to the following:
Date: Wed, 28 Jan 2009 12:10:34 -0800 (PST)
Message-ID: <783ee951-6678-4888-9628-0797d8207230_at_r34g2000vbp.googlegroups.com>
I have a SELECT statement similar to the following:
SELECT YEAR(transaction_date) AS y,WEEK(transaction_date) AS w, COUNT (*) AS c FROM transaction_data_view WHERE mid = 300 GROUP BY YEAR(transaction_date),WEEK(transaction_date) ORDER BY YEAR(transaction_date),WEEK(transaction_date);
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. Of course, my real select statement is much more complex than this, involving joins of both tables and views (and it is quick), but this suffices to make the only remaining problem obvious.
Thanks,
Ted Received on Wed Jan 28 2009 - 21:10:34 CET