Only if you get real clumsy 😀

Peter E. Kierstead (7/2/2008)

---

Yes, every technique has its achilles heel... one of the CTE's is the recursion level...

But this works great for most things I used to use WHILE loops...

Toby White (6/27/2008)

---

I am doing a bulk insert of 132,873,975 rows that are ordered by zip code. The receiving table has 2 indexes on it and a 3rd possible clustered...

John Rowan (7/2/2008)

---

Not trying to be obtuse, but can you expand on this a bit Jeff? What issues are there with BCPing directly into the final table? Also,...

Not what I was referring to... some folks just feel that they've gotta put an index on...

John Rowan (7/2/2008)

---

Not trying to be obtuse, but can you expand on this a bit Jeff? What issues are there with BCPing directly into the final table? Also,...

Peter E. Kierstead (7/2/2008)

---

Ok... no WHILE loop, no TALLY table...

Declare @OldStr VarChar(max),@NewStr VarChar(max);

Select @NewStr='',@OldStr='ab123c';

With NumOnly as

(

Select Case when SubString(@OldStr,1,1) like '[0-9]' then SubString(@OldStr,1,1) else '' End[Chr],1[Idx]

Union All

Select Case when SubString(@OldStr,Idx+1,1)...

Ummmm... isn't THAT a bit of an oxymoron? 😀

Track you down? Heh... I'm putting my Avatar on the back of a...

You didn't know it was a mostly ETL job going in? Company either made a mistake or weren't getting any responses to begin with so changed the JD.

Rule of thumb says "Never BCP directly into the final table." Applies for this, as well... especially this. Load the million rows into a new staging table, then...

Wow...

I'm with Gus, but let me go one step further. With 5000 procedures (I assume that's like saying "a bazillion"), and all those ugly WHERE clauses, etc, etc, I...

And, now... I'm just making a royal pain of myself by trying to answer everyone... Thank you all for the great support and I won't let you down in the...

We can do that! I'll actually be at PASS this year!...

Jim Russell (7/2/2008)

---

Congrats to both. I am particularly delighted to see Jeff get the recognition he so richly deserves. (Just hope he doesn't get so involved in whatever MVPs do...