SQL Pivot Table with Dynamic Columns

Last week, I was tasked with sending out an email of hourly production data that was to be read on blackberry phones. It started off as something really simple; just sending a plain html table in an email.

Something like this:

tabular data

Moreover, this turned into something much more complex when I found out that I needed to create a pivot chart which displayed the hourly times as dynamic columns. I had never been asked to do anything like this before, and It took me a little bit out of my comfort zone. However, after finding a ton information on this topic, this task became relativily easy.

How to create a pivot chart with dynamic columns?

<cfquery name="qryPivot" datasource="#nscdb#">
        DECLARE @columns VARCHAR(8000)
        SELECT @columns = COALESCE(@columns + ',[' + cast(Date as varchar) + ']',
                                 '[' + cast(Date as varchar)+ ']')
        FROM    vGroupMail
        GROUP BY Date

        DECLARE @query VARCHAR(8000)
        SET @query = '
        SELECT *
        FROM vGroupMail
        PIVOT
         (
         MAX(Pac)
         FOR [Date]
         IN (' + @columns + ')
         )
         AS p'
        EXECUTE(@query)
        </cfquery>