Transpose Row into columns

• naseer78_pk

  Mr or Mrs. 500

  Points: 592

  More actions

  March 20, 2012 at 1:58 am

  #253308

  HI,

  I have a phoneDetail Table of my customers

  CustomerIDRowPhone Type DefaultFlgContactPersonContactNumber

  1 1CompanyPhone1 Richard 1876-926-04545

  1 2Home Phone0 Richard 1876 946 04789

  1 3Mobile 0 Richard 495 6764/882222

  1 4Fax 0 Richard 1876-929-1885

  1 5Fax 0 Richard 1876-882-555

  1 6Fax 0 Richard 1876-960 666

  I need output:

  CustomerIDContactPersonCompanyPhone Home Phone Mobile Fax DefaultFlg

  1 Richard 1876-926-0905 1876 946 0444495 6764/88274711876-929-1485 1

  1 Richard NULL NULL NULL 1876-882-7471 0

  1 Richard NULL NULL NULL 1876-960 3882 0

  Thanks in Advance

  Regards,

  NA

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  March 20, 2012 at 2:58 am

  #1461495

  Duplicate post.

  Replies here please: http://www.sqlservercentral.com/Forums/FindPost1269385.aspx

  -- Gianluca Sartori