how to create a table from the given string with row separator as "," and column separator as "|".

• asashank82

  SSC Journeyman

  Points: 96

  More actions

  February 1, 2010 at 6:10 am

  #142025

  Hi Friends,

  how to create a table from the given string with row separator as "," and column separator as "|".

  For Eg.:

  @array varchar(max),

  @RowDelim varchar(10),

  @ColDelim varchar(10)

  I will pass the values to the above parameters from the frontend in this way:

  @array = 'a12,b23,c34|d,45e56,f67|g78,h89,i90'

  @RowDelim = '|'

  @ColDelim = ','

  and i need the output to be returning a table as :

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

  Col1 Col2 Col3

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

  a12 b23 c34

  d45 e56 f67

  g78 h89 i90

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

  i can t pass XML. I need to pass on String to the SP.

  Thanks

  Aditya

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  February 1, 2010 at 6:15 am

  #1111550

  Did you read this ? http://www.sqlservercentral.com/articles/T-SQL/63003/

  It tells you all you need to know.

  Are you having trouble with it ? If so what is unclear ?

  ---

  
  Clear Sky SQL
  My Blog[/url]