question - urgent - thanks in advance

• RPSQL

  Hall of Fame

  Points: 3229

  More actions

  January 25, 2010 at 9:54 am

  #218517

  urgent development question:

  i have a table something like this

  name,

  student id,

  subjects

  in subjects column we have subjects taken by each student seperated by semicolumn.i.e. "english;social study;crafts" etc.

  now, I want output table which is seperated by each subject...i.e.

  before

  ------

  name | student id | subjects

  stdA| 123| english;social study

  stdB| 234| social study;crafts

  After

  -----

  name | student id | subjects

  stdA| 123| english

  stdA| 123| social study

  stdB| 234| social study

  stdB| 234| social crafts

  ....

  Please help me as this is urgent.

  Thanks.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  January 25, 2010 at 10:06 am

  #1108251

  Please don't cross post. It just wastes peoples time and fragments replies.

  No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic853117-145-1.aspx

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• RPSQL

  Hall of Fame

  Points: 3229

  More actions

  January 25, 2010 at 10:28 am

  #1108274

  Sorry GilaMonster