convert the columns into rows

• l_srinuu

  SSC Journeyman

  Points: 87

  More actions

  September 22, 2009 at 3:51 am

  #156239

  I need provide me script / procedure to convert the columns into rows ..Please help

  Table#1

  Job Name1_1 name1_2 name1_2 name1_4 city1_1 city1_2 city1_3 city1_4 phone1_1 phone1_2 phoen1_3 phone1_4

  Xyz aaaa bbbb cccc dddd abcd bcde cdef defg 1111 2222 3333 4444

  output table as:

  Job name city phone

  Xyz aaaa abcd 1111

  Xyz bbbb bcde 2222

  Xyz cccc cdef 3333

  Xyz dddd defg 4444

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  September 22, 2009 at 3:58 am

  #1056644

  Please dont cross post

  http://www.sqlservercentral.com/Forums/Topic791603-5-1.aspx

  ---

  
  Clear Sky SQL
  My Blog[/url]