So, you're doing a crosstab report? Shouldn't the heading be the job of your front-end?

Here is one of the most-referenced tools for this:

http://www.rac4sql.com

Shouldn't be too difficult to combine the result with DATENAME to get what your after.