convert columns to rows in a table

• chinni-652949

  Default port

  Points: 1425

  More actions

  April 11, 2008 at 11:48 am

  #184364

  i have a table like

  table1

  aa bb cc dd

  1 2 3 4

  5 6 7 8

  i need to convert columns in to rows...............( to use in reporting)

  table2

  aa 1 5

  bb 2 6

  cc 3 7

  dd 4 8

  and the number of columns/rows are not fixed..........as this table1 is present in cursor.......for each iteration the number of columns may change........................

  thanks in advance

• Robert-378556

  SSCertifiable

  Points: 5917

  More actions

  April 15, 2008 at 5:34 am

  #802456

  Take a look at UNPIVOT operator in BOL.

  http://msdn2.microsoft.com/en-us/library/ms141723.aspx

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