SELECTING ROW VALUES AS COLUMN BASED ON A KEY

• shashidhar.bussa

  SSC Veteran

  Points: 211

  More actions

  January 29, 2008 at 11:21 pm

  #70729

  I had a scenorio where i need to retrieve the row values in column values.

  Let me Explain with the below Example:

  Table :

  Transaction_ID | PID | Field_key

  B001 | 4 | A

  B001 | 4 | B

  B001 | 4 | C

  C001 | 2 | 100

  C001 | 2 | 200

  Please Note that: This table doesn't have any Primary Key or Unique Key

  OUTPUT Should be

  Transaction_ID | PID | Field_Key1 |Field_Key2 | Field_Key3

  B001 | 4 | A | B | C

  C001 | 2 | 100 | 200 | NULL

  Thanks,

  shashidhar

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  January 30, 2008 at 4:24 am

  #773188

  Look in books online for the PIVOT clause for SELECT statements.