Hi,

I have similar issue.

I have managed to create pivot in SQL 2005 for date column header but problem is while exporting the data into some flat file i am not able to retrieve Column header. infact i cant map them since the column are dynamic.

Kindly help me in this regard,

Deepika