CTE experssion to seperate comma delimited rows

• EamonSQL

  SSCrazy

  Points: 2307

  More actions

  May 1, 2009 at 12:31 am

  #155639

  Hi,

  I have a table with data in columns that are delimited by commas .

  MyTable(

  gid varchar(5),userids varchar(50)

  )

  gid userids

  1 john,fred,mary

  2 ted,bob

  I need to return the following :

  gid userids

  1 Mary

  1 fred

  1 john

  2 ted

  2 bob

  I haven't used CTE expessions before and all I can find is CTE expressions that do it for a local variable.

  Has anyone ever done this before?

  I'd appreciate any help out there.

  Thanks,

  EamonOD 🙂

• Kruti Kansara

  Hall of Fame

  Points: 3118

  More actions

  May 1, 2009 at 1:03 am

  #987169

  Hope the below links will help you...

  http://www.sqlservercentral.com/articles/Development/commontableexpressionsinsqlserver2005/1758/

  http://searchwindevelopment.techtarget.com/tip/0,289483,sid8_gci1278207,00.html

  "Don't limit your challenges, challenge your limits"