Pivot In Values with dates?
At the end of my sql, I am using the following code. Is there any way of replacing the fixed strings [2011/07/14], [2011/07/16], etc, to GetDate() value?

    PIVOT 
        (
           count([AppointmentsBooked])
           FOR [date] IN ([2011/07/14], [2011/07/16], [2011/07/17],[2011/07/18],[2011/07/21])
        ) as pivottable
Pivot In Values with dates?
===

At the end of my sql, I am using the following code. Is there any way of replacing the fixed strings [2011/07/14], [2011/07/16], etc, to GetDate() value?

    PIVOT 
        (
           count([AppointmentsBooked])
           FOR [date] IN ([2011/07/14], [2011/07/16], [2011/07/17],[2011/07/18],[2011/07/21])
        ) as pivottable