Transpose Column in table

• pxt_ce

  SSC Eights!

  Points: 830

  More actions

  October 29, 2009 at 5:11 am

  #99894

  create table TableA

  ( A int , B int ,c int )

  insert into TableA -- we need to insert only one row

  (1,2,3)

  and i want result like

  TableB

  Col1

  1

  2

  3

• Nabha

  SSCrazy Eights

  Points: 8534

  More actions

  October 29, 2009 at 5:38 am

  #1072353

  you need unpivot for this, take a look at the example in this link please.

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

  Just in case if you need the query,

  create table #t

  ( A int , B int ,c int )

  insert into #t Values-- we need to insert only one row

  (1,2,3)

  Select Val FROM

  (Select A,B,C from #t) P

  UNPIVOT (Val FOR val1 in (A,B,C)) unpvt

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