Convert Column to Row

• jeganbenitto.francis

  SSC Eights!

  Points: 956

  More actions

  March 19, 2014 at 4:46 am

  #291078

  Can some one help me to fix my issue now.

  On Entering a query , I get Ouput as below

  col1col2col3

  c1v1c2v1c3v1

  c2v1c2v2c3v3

  c3v1c3v2c3c3

  But i want to convert column to row and get output as below.

  Can some help now.. I do not want to use Union

  col1c1v1c2v1c3v1

  col2c2v1c2v2c3v2

  col3c3v1c3v3c3c3

  Thanks,

  JB

• HanShi

  SSC-Dedicated

  Points: 33507

  More actions

  March 19, 2014 at 7:01 am

  #1698353

  Read this article http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/. You most likely can solve your question with the information from this article.

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **