Split a string into rows

• Bill Maners

  Ten Centuries

  Points: 1340

  More actions

  August 3, 2011 at 11:08 am

  #241181

  Hi,

  I have a requirement to turn this single row (2 columns)

  1,abc

  into 3 rows (2 columns)

  1,a

  1,b

  1,c

  Hopefully without using loops/cursors.

  Any ideas?

  Thanks, Bill

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 3, 2011 at 11:10 am

  #1363237

  http://www.sqlservercentral.com/articles/T-SQL/62867/

• Bill Maners

  Ten Centuries

  Points: 1340

  More actions

  August 3, 2011 at 11:36 am

  #1363248

  Thanks!!