How can I use aggregates and the group by clause with FOR XML?

Is there anyway I could return an XML with a SUM/GROUP BY clause in the select?!? This is actually fairly simple to implement. For this example I will use the pubs database. The first step is to create the query you want to use. For our example we will count how many titles each author has.

Read More - Register for Free Membership