Sure. If you run into problems, reply back. It is really simple to use - copy the function from the article - it is under the heading "The Final "New" Splitter Code, Ready for Testing". Run it in a query window to install the function. Then use it like in the example belowCREATE TABLE #tmp(Id VARCHAR(32));
INSERT INTO #tmp VALUES ('89'),('89/70'),('89/71');
SELECT
Id,
[1] AS Col1,
[2] AS Col2,
[3] AS Col3
FROM
#tmp t
CROSS APPLY (SELECT * FROM
dbo.DelimitedSplit8K(Id,'/')) d
PIVOT (MAX(Item) FOR ItemNumber IN ([1],[2],[3]))P
DROP TABLE #tmp;
splitting string into multiple columns
Posted - 02/06/2013 : 08:57:05
