Need help to split Multiple Columns into One column..

• panneer.adms

  Grasshopper

  Points: 19

  More actions

  October 11, 2011 at 2:47 am

  #260259

  Hi,

  I have a Query Result like following

  id Name Mark1 Mark 2 Mark3 Mark4 mark 5

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

  1 AAAA 75 85 45 65 85

  But i need result like

  Details

  -------

  1

  AAAA

  75

  85

  45

  65

  85

  How do i get Result..

  Please help me...

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  October 11, 2011 at 4:17 am

  #1392741

  Duplicate post.

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

  -- Gianluca Sartori