Viewing 3 posts - 1 through 3 (of 3 total)
It is working like a champ and doing what it needs to do. Thanks for checking in.
July 25, 2013 at 6:36 am
#1635681
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!
July 24, 2013 at 2:40 pm
#1635531
Luis Cazares (7/24/2013)
You can check which character is with this code (it's untested, but it should work).
WITH E1(N) AS (
...
July 24, 2013 at 2:39 pm
#1635530