Would you please provide a simple solution to parse the string?

• C.K.Shaiju

  SSCarpal Tunnel

  Points: 4228

  More actions

  August 19, 2011 at 5:59 am

  #243538

  I have to parse 2 strings from 2 columns of a table. I did that in 2 different ways. One with SUBSTRING() and other with TEMP Table. But feel those are too complex codes.

  Would you please check the code to get a simple solution?

  I have attached both my scripts here.

  Thanks in advance.

  _____________________________________________
  One ounce of practice is more important than tonnes of dreams

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 19, 2011 at 6:17 am

  #1370661

  http://www.sqlservercentral.com/articles/Tally+Table/72993/