I think we lost him a long time ago. He never did answer if it was for a single parameter or for a whole column....

Heh... I might have it, ol' friend... I can't explain it, I just gotta do it. I'll be back. And you're right about the table... 3 columns. 🙂

By the way, when I said "It sure does", I meant it sure does fail... and in exactly the manner you suggested. Sorry for the confusion. 🙂

I'll be back......

Ya beat me to it, John. 🙂

Not 100% sure but, using your good data, I think example 1 was meant to be something on the order of...

-- Example 1

DECLARE @EMail...

Heh... thanks for the awesome feedback, Dugi.

Still,...

Manie, I gotta say it again... good article. You brought some good people out in the discussion about PatIndex. Nicely done! 🙂

dphillips (9/16/2008)

---

Jeff, great examples and test building. It amazes me you have the time to post such significant and applicable content and in such detail.

Thank you for your many...

Can you show us one, Sergiy... so we can get the idea of how to do it? Thanks.

Could re-export what...

It sure does...

... but the OpenRowSet thing I showed does it right.

Great info! I gotta try it. Thanks.

Cool! I'd guessed wrong. ColumnC in the orginal code wasn't prefixed by a table alias and I'd guessed it was in Table1. Thanks.

Ummm... all those bloody REPLACE's are gonna be slow. I just thought of another way using our friends the Tally table and the "quirky update". It'll take me...

Heh... yeah, I wouldn't want to take a call in the middle of a cold one, either.

Split functions always work, especially on a single delimiter. Obviously, your stuff has...

BTW... as you already know, the rows you originally posted import just fine because they are, despite appearances, properly formatted CSV's. The delimiters also line up and could be...