Convert Column Name and Values as New Row

• tibco29

  SSChasing Mays

  Points: 655

  More actions

  March 27, 2014 at 12:11 am

  #291545

  Hi friends,

  I want to do below task from input format to Output format, any help would appreciated.

  INPUT

  pn rvs respamountchargeadjust

  MS0003447 97014A-12.79 30 17.21

  OUTPUT

  pn rvs respamountchargeadjust

  MS0003447 97014A-12.79 30 00.00

  MS0003447 97014 adjust 0.00 0.00 17.21

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  March 27, 2014 at 4:00 am

  #1700600

  SELECT pn, rvs, resp, amount, charge, adjust = 0.0

  FROM MyTable

  UNION ALL

  SELECT pn, rvs, resp = 'adjust', amount = 0.0, charge = 0.0, adjust

  FROM MyTable

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP