InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 02:20:34 GMT20http://www.sqlservercentral.com/Forums/Topic526829-149-1.aspxThis article has data on splitting into multiple columns:http://www.sqlservercentral.com/articles/T-SQL/63003/Wed, 02 Jul 2008 08:25:53 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic526829-149-1.aspxHow is this procedure invoked if the input is in a table #testTue, 01 Jul 2008 17:27:26 GMTraymhttp://www.sqlservercentral.com/Forums/Topic526829-149-1.aspxBUt this splits the string into one column. I want to split it into 14 columns so the result set is likecol1 col2 col3 ..........how do I achieve that ?Tue, 01 Jul 2008 17:25:22 GMTraymhttp://www.sqlservercentral.com/Forums/Topic526829-149-1.aspxhttp://www.sqlservercentral.com/articles/TSQL/62867/That article has data on how to split a delimited string efficiently, and a bunch of other good stuff that's related to that.Tue, 01 Jul 2008 15:27:29 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic526829-149-1.aspxHi,Check out the below linkhttp://www.dotnetspider.com/resources/1266-Split-e-String-Using-char-separator.aspxThanks -- Vjhttp://dotnetvj.blogspot.comTue, 01 Jul 2008 12:35:54 GMTVijaya Kadiyalahttp://www.sqlservercentral.com/Forums/Topic526829-149-1.aspxHow can I split this string into the columns in the first line so I can insert it into a tablewith the 14 Columnsif object_id('tempdb..#test') is not nulldrop table #testgoCreate Table #test (String varchar(8000))Insert #test Values ('''"Col1","Col2","Col3","Col4","Col5","Col6","Col7","Col8","Col9","Col10","Col11","Col12","Col13","Col14"')Insert #test Values ('''125020000065417,0220,01,00, ,2008/06/30 08:14:28,710,500.000000,710,500.000000,424477,00000000,113927,Dont worry about it')Insert #test Values ('''214570001560883,0220,00,00, ,2008/06/30 08:14:46,710,30.000000,710,30.000000,424477,00000000,114001,Dont worry about it')Insert #test Values ('''125020000395491,0100,01,00, ,2008/06/30 08:15:53,710,420.000000,710,420.000000,424477,82260001,114063,Dont worry about it')Insert #test Values ('''125020000067371,0100,30,00, ,2008/06/30 08:33:24,710,0.000000,710,0.000000,424477,80900001,114069,Dont worry about it')Insert #test Values ('''125020000367698,0100,01,00, ,2008/06/30 08:39:16,710,500.000000,710,500.000000,424477,TL335040,114074,Dont worry about it')Insert #test Values ('''125020000367698,0100,01,00, ,2008/06/30 08:41:14,710,500.000000,710,500.000000,424477,TL335040,114075,Dont worry about it')Insert #test Values ('''125020000067371,0100,01,00, ,2008/06/30 08:43:14,710,380.000000,710,380.000000,424477,80900001,114076,Dont worry about it')Insert #test Values ('''125020000345629,0100,01,00, ,2008/06/30 09:17:14,710,1000.000000,710,1000.000000,424477,SASC3021,114094,Dont worry about it')Insert #test Values ('''125020000462424,0100,30,00, ,2008/06/30 09:21:22,710,0.000000,710,0.000000,424477,80450001,114098,Dont worry about it')Insert #test Values ('''125020000336693,0100,30,00, ,2008/06/30 09:21:42,710,0.000000,710,0.000000,424477,80970001,114099,Dont worry about it')Insert #test Values ('''125020000420281,0100,01,00, ,2008/06/30 09:33:04,710,1200.000000,710,1200.000000,424477,87670001,114104,Dont worry about it')select * from #testTue, 01 Jul 2008 11:35:45 GMTraym