Convert Row values to Columns

• ravindra.gangadhar

  SSC Enthusiast

  Points: 122

  More actions

  December 17, 2007 at 3:14 am

  #181375

  Hi Guys,

  I have table which retrives values and i want to convert those values to columns but the values are not fixed it may increase.

  example

  ID TEXT

  ------------------------

  1 US

  2 UK

  3 SINGAPORE

  etc....

  Required Result.

  US UK SINGAPORE 'ETC.......

  Please advise for a single query without using any temp tables,SP's or functions others...

  Please advise.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  December 17, 2007 at 8:57 am

  #760725

  Please don't cross post. This is being answered here: http://www.sqlservercentral.com/Forums/Topic433813-338-1.aspx