I have a table with about 10 columns
Date In text format JAN-09
I would like to do two things...
Aggregate up all the sales by summing units sold for each month
And also sum up the volume sold.
This should be returned by the same query.
All the other columns should be brought across with no calcs ie the units and this suming should be done at the month level so i have to split the month off from the string as well.
Thanks for help...