Don't know if this will help you as an example pivot to show dates as columns and count in cells, you can alter it to suit:select Column A , [01/01/2012] as '01/01/2012' , [02/01/2012] as '02/01/2012' , [03/01/2012] as '03/01/2012' , [04/01/2012] as '04/01/2012' , [05/01/2012] as '05/01/2012' , [06/01/2012] as '06/01/2012' , [07/01/2012] as '07/01/2012' , [08/01/2012] as '08/01/2012' , [09/01/2012] as '09/01/2012' , [10/01/2012] as '10/01/2012' , [11/01/2012] as '11/01/2012' , [12/01/2012] as '12/01/2012'FROM (select column A , column B , column C FROM Table) psPIVOT(COUNT(Unique_Instance)FOR Instance_Date IN ([01/01/2012] ,[02/01/2012] ,[03/01/2012] ,[04/01/2012] ,[05/01/2012] ,[06/01/2012] ,[07/01/2012] ,[08/01/2012] ,[09/01/2012] ,[10/01/2012] ,[11/01/2012] ,[12/01/2012])) AS PVT