InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 11:19:23 GMT20http://www.sqlservercentral.com/Forums/Topic1356639-391-1.aspxMaybe I'm reading it wrong, but short of going into CLR (which I personally try to avoid for maintainability) CTE dosen't seem to be much slower?I mostly liked the link I provided for it's simplicity, but then again I'm not in need of break neck speeds, my script will only be running about once per day when noone else is logged in, so a couple of extra milliseconds wont matter ;)Wed, 10 Oct 2012 08:43:21 GMTFantasticahttp://www.sqlservercentral.com/Forums/Topic1356639-391-1.aspx[quote][b]Fantastica (10/10/2012)[/b][hr]Bit of a late answer, but found this usefull when I had this same problem.[url=http://www.syntaxwarriors.com/2012/t-sql-splitting-strings-into-multiple-rows/]http://www.syntaxwarriors.com/2012/t-sql-splitting-strings-into-multiple-rows/[/url]Even has an example of how to make sure that any other columns of data are moved along with the split values.[/quote]The article reference by Andy explains why the process at the link you posted will work but performs a lot slower.Wed, 10 Oct 2012 07:56:37 GMTSean Langehttp://www.sqlservercentral.com/Forums/Topic1356639-391-1.aspxBit of a late answer, but found this usefull when I had this same problem.[url=http://www.syntaxwarriors.com/2012/t-sql-splitting-strings-into-multiple-rows/]http://www.syntaxwarriors.com/2012/t-sql-splitting-strings-into-multiple-rows/[/url]Even has an example of how to make sure that any other columns of data are moved along with the split values.Wed, 10 Oct 2012 06:11:40 GMTFantasticahttp://www.sqlservercentral.com/Forums/Topic1356639-391-1.aspxHiTake a look at this link:[url]http://www.sqlservercentral.com/articles/Tally+Table/72993/[/url]AndyMon, 10 Sep 2012 04:50:48 GMTAndy Hyslophttp://www.sqlservercentral.com/Forums/Topic1356639-391-1.aspxHi, I'm trying to split a single column into a number of columns, with the split being the delimiter of '-'I have enclosed an excel example of what I am trying to achieve.If anyone could help, that would be greatThanks in advance for your help.Mon, 10 Sep 2012 04:37:24 GMTDBayliss