I miss the old brute force days... they were much more "fun" 🙂

Thanks, Steve! Between that and the fact that you guys fixed the copy/paste formatting problems in the code window and the normal text area, I can spend a whole...

I always worry about these types of things because I've interviewed a lot of people to be SQL Developers... a lot of them fail such simple questions because they were...

heh... and I have a special batch of porkchops on the next one 😉

Marios Philippopoulos (3/17/2008)

---

Trace flag 1222 is new to SQL Server 2005 and gives XML-like output, which is much easier to manipulate programmatically, should one be interested in producing a report.

I...

Trader Sam (3/17/2008)

---

Don't worry about it ... we all have our moments. That's why it helps having so many sets of eyes on here...

Mixed bag, actually... some of it is from ShoGun...

Heh... "Always look eye, Angisan..."

Let me ask it a slightly different way... could the content of the staging table be used to replace 100% of the final destination table in production?

You're still not telling the whole story here... you already said the staging...

I don't have 2k5 at work... I'll have to wait until tonight to find out what's happening. Could you send the output you're getting so we can do a...

Yes... transaction log builds up... previous code tried to do it all at once and didn't let anyone else in... etc, etc. The crawler I suggest will avoid all...

biscuit (3/17/2008)

---

Jeff, I did try your code and it worked very nicely. But if you will look at the third resultset, you can see where it returned 123456789...

Doesn't WriteText only affect one row?

I'm pretty sure that you haven't tried my code... give it a try... it's designed to avoid the very problem you mention.