Display columns as Rows

• PriyaBabu

  Mr or Mrs. 500

  Points: 535

  More actions

  July 28, 2009 at 3:41 am

  #133514

  Hello,

  ColA ColB ColC ColD ColE

  1 2 3 4 5

  1 null 6 null null

  1 7 null 8 null

  1 null null null 9

  The above is a table that contains the history of changes.

  I need a query which would display the result as

  Colb 2

  colb null

  colb 7

  colb null

  colc 3

  colc 6

  colc null

  colc null

  etc.

  Could you please help me with this

  Thanks in advance.

• sql_lock

  SSCrazy Eights

  Points: 9373

  More actions

  July 28, 2009 at 4:12 am

  #1030931

  have you tried..

  http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=66407

• Kari Suresh

  Hall of Fame

  Points: 3712

  More actions

  July 28, 2009 at 4:44 am

  #1030943

  Hi,

  You can use PIVOT. Check this link:

  http://msdn.microsoft.com/en-us/library/ms177410.aspx

  KSB.

  KSB
  -----------------------------
  Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha