Home Forums SQL Server 2008 T-SQL (SS2K8) Using DelimitedSplit8k against a Space Delimited Field - Problems RE: Using DelimitedSplit8k against a Space Delimited Field - Problems
james.rosser
SSC Enthusiast
Points: 102
More actions
July 24, 2013 at 2:40 pm
#1635531
Resolved it myself whoops! This works:
Select sd.CoreID, sd.ComputerID, sd.ResultsText
From SampleData sd
cross apply dbo.DelimitedSplit8k(sd.ResultsText, char(10))
Thanks Luis!