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

  • July 24, 2013 at 8:48 pm

    #1635583

    james.rosser (7/24/2013)

    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!

    I don't see where you're actually using anything from the function. Are you sue it's doing what you want?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)