I have 20 million records, each has a date. About 50,000 exist on each day.
I want to be able to create an aggregate table based on the date. It needs to be aggregated into month/year.
As I am not hugely famialiar with SQL yet, it would be great to understand if this can be done in the query designer. If not, suggestions on the SQL are most welcome.