So, does it actually work for...

Admin 2009-02-18 18:23:43.437 2009-02-19 12:12:19.357

Recursion is sexy... and, recursion is slow. I recommend avoiding it whenever you can. The following code takes 93 CPU milliseconds to parse 1821 elements on my humble...

Edward Boyle (2/18/2009)

---

Below is a function based on recursion for parsing a string with a specfied delimiter

Go

If Object_id('GmtGetTokens') is not null drop Function GmtGetTokens

GO

Create Function dbo.GmtGetTokens(

@AllElse Varchar(8000),

...

Simple aggregates with GROUP BY should do the trick.

Heh......

Then why are so many shocked at a "lift your leg and let it rip" fart in public? 😀

Sorry... I got a little busy... looks like you've got a good answer with the UNPIVOT solution.

Heh... yeah... I wish MS would figure out that T-SQL is a great place to do ETL from and that you don't really need SSIS... in fact, if you hold...

Thanks for sharing your hard earned code. Here's an alternative that doesn't involve (essentially) "screen scraping" a DOS window and doesn't use xp_CMDShell... In 2k5, we could probably...

They do it because they think they're in Dev but they're actually in production. It's what happens when you open more than one server on your desktop at a...

Thanks for the feedback, Karen. I know there's a lot of them, but some of the posts in the discussions in this thread show some pretty nifty ways to...

Outstanding... thank you very much for taking the time to stop by and make a comment. All of us do this stuff for free and our only reward is...

That's some good info, Luke. Thanks for sharing it with us.

Phil Factor (2/19/2009)

---

Perl is great, and I've used it a fair bit, but it is a Smörgåsbord. You want something? It gets bolted on somehow. What you don't get is...

I haven't had such a problem in a while, but for things like BULK INSERT and BCP, I seem to remember this type of thing happening with the file type...