I'm working with charts in Flash and need to create an xml file that will store the data for Flash to access. I was wondering if there was an easy way to do this:
I want 1 query that will count totals from one date to another. So something like this:
6/09 - 125
6/10 - 55
6/11 - 0
6/12 - 15
6/13 - 581
6/14 - 33
I know I could just do 7 queries but if the date range is a lot higher I could end up doing a ton of queries.
So I was just wondering if anyone had a solution to returning that information in 1 query.