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

  • 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!