I have a table with news, one of the fields is 'date'.
I am using ASP/VBscript. and MS SQL 2008.
I need two queries.
First one will group all news posted in previous years by year display the year and the number of news which have that year. So for example it will display, this ONLY for the previous 3 years
Second query will display the total of all news older than the past three years (current doesnt count), example above would be any from Dec 31st, 2008 and before then.