Month and Year

Hi,
I need to get the totals for each month from a SQL Server DB. I can do it but the problem is I then need to chart it so I need to group on the month/yyyy.

So the query needs to have an "AS monthyear". I can get the month and the year separately using DatePart but how do I get them together?

Thanks,
Jen

METHOD 1: (BAD)
CAST the month and year as strings and join them into one string...
Use the string as the primary key.

METHOD 2: (GOOD)
Group by month and year individually (2 fields)
The 2 fields together form your primary key.
then u can still display month and year together in one string if you want to

How r u presenting this info? in a website?

__________________
Diego - Web-Developer & London SEO Expert
jQuery Plugins: Multiple File Upload, Star Rating, FCKEditor | NEW: XML to JSON