Create Pivot , Exporting the result into flat file with Column Header

• BI_NewBie

  SSCrazy

  Points: 2261

  More actions

  October 4, 2013 at 4:56 am

  #395608

  Dear All,

  I am trying to create pivot of some table.

  some how i managed to create pivot. Now i am exporting the resultant data into flat file. while doing so i am unable to retrieve column headers since while creating pivot column headers are dynamic.

  I am using BCP command to export the data into txt.

  1. Select * from Table : giving me only data not column

  2. SELECT [Column 1], [Column 2].... ---> I cant use this query since my column are dynamic and that depends on the data i have in my table.

  How to get dynamic column headers into flat file????

  Please help me with this.

  Thanks

  Regards,

  Deepika

• siggemannen

  SSCrazy

  Points: 2436

  More actions

  October 11, 2013 at 4:07 pm

  #1658040

  Why not have a UNION of two selects?

  One that selects column names for the first row and another that selects actual data?