Re: Selecting and ordering data over multiple date ranges

One way would be to GROUP BY state and month -- not just state, but your output would change to rows like this:

New York  Jan  115
New York  Feb  100
New York  Mar    0
Georgia   Jan   28
[download]

Comment on Re: Selecting and ordering data over multiple date ranges Download Code

Replies are listed 'Best First'.
Re: Re: Selecting and ordering data over multiple date ranges by CountZero (Bishop) on Feb 07, 2003 at 16:43 UTC
If you save these results in a HashofHashes (keyed by the name of the State and the month), the reformatting into a table with State-rows and Month-columns will be easy (and left for the attentive student as an exercise). CountZero "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law	[reply]