Jeff Moden (6/27/2010)
...Yes... you are correct... the search capabilities on this forum suck. I'm sure that Lutz will be back soon with his split function.
That's something I cannot confirm (at least not in this case...)
Search string: DelimitedSplit8K returned the following thread on the first page:
Thread name: SP error
... FROM #List l CROSS APPLY DelimitedSplit8K(l.List, @Delimiter) f [/code] See how the DelimitedSplit8K function returns a table that can be joined ... From HC_USERS CROSS JOIN DelimitedSplit8K(@rid, ',')[/code] Finally, clean up ...
This thread include a post by WayneS showing the DelimitedSplit8K function I'm using at the moment.
But I admitt, it's always easier to find something once you know where to look and what to look for...
@mishaluba: As a side note: please check the author of that script and see if the name rings a bell 😉
@jeff: I'm sure you know that I don't have my own split function. Right? 😀