Building a table

• lrosales

  SSCommitted

  Points: 1821

  More actions

  September 16, 2009 at 9:39 am

  #138201

  Hello

  i need some suggestions. I am running a query on two columnns (A1, A2)

  I want the results of columns (A1) to become the Header and column (A2)

  to become the Data

  any ideas on how I can accomplish this?

  😀

  "We never plan to Fail, We just fail to plan":)

• rjv_rnjn

  Hall of Fame

  Points: 3023

  More actions

  September 16, 2009 at 9:47 am

  #1054565

  PIVOT may help you.

  A good article on it here: http://www.sqlservercentral.com/articles/T-SQL/63681/