PIVOT Function ?

• SQL_path

  SSCrazy

  Points: 2810

  More actions

  October 26, 2011 at 7:57 am

  #262085

  Hi,

  I have data in following format from my variable table

  ID ! TEXT

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

  1 ! ABCD

  1 ! EFGH

  how can I make

  ID ! TEXT 1 ! TEXT 2

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

  1 ! ABCD ! EFGH

  Thanks

• GSquared

  SSC Guru

  Points: 260824

  More actions

  October 26, 2011 at 8:20 am

  #1399640

  Duplicate post.

  Please post replies at: http://www.sqlservercentral.com/Forums/Topic1196314-1291-1.aspx

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon