Stefan Krzywicki (4/11/2011)

---

GilaMonster (4/11/2011)

---

Stefan Krzywicki (4/11/2011)

---

Believe me, I don't want to be using a cursor, but it is part of production code and every time I mention changing it to...

Sure it is. Just remove everyone's system access. Then they can't give...

Scope creep.

(and, lemme tell you, Mr. Scope is definitely creepy. @=)

HA! As if.

Cluster down again. Much scrambling to get things working before the BU showed up.

Does it count as murder if...

That's what I figured. But fortunately, that's not a problem for me today.

Jeff Moden (4/7/2011)

---

Brandie Tarvin (4/7/2011)

---

Well, that was harder than it needed to be. And the solution is easier than I expected. Now I just have to replace my field values...

My only issue with sorting was making sure I didn't have two copies of the same record with the errors flipped (Ship Date; Sale Date vs Sale Date; Ship Date)....

Update from the front. I have replaced my multiple inserts with an UNPIVOT. Rather than compare 15 different columns as listed above, I've done the following:

ALTER TABLE DT.Staging

ADD...

I got my parents copies of The Shadow radio show for their anniversary many years back. They loved it. It was one of those things they'd listen to when they...

Jeff, He's questioning opc.three's script solution (not Lowell's XML solution).

opc.three (4/7/2011)

---

Brandie Tarvin (4/7/2011)

---

Wow. I wonder if they had permissions to reprint that article. I found it yesterday at Simple Talk.

Or maybe it was the guy at Simple Talk...

Okay, so repeating what I have...

CREATE TABLE dbo.#TempErrors (DocID int, FieldType varchar(20), ErrorDetail varchar(400));

GO

INSERT INTO dbo.#TempErrors (DocID, FieldType)

SELECT DocID, 'DocumentNumber'

FROM MyStagingTable

WHERE 'DocumentNumber'IS NULL OR 'DocumentNumber'='';

/* repeat ad naseum for...

Stefan Krzywicki (4/7/2011)

---

Absolutely, that first series was great. I like that they still get occasionally...

Oh, duh. You're right and Lowell's right, of course. And that works so much better then the other stuff I've come up with.

Sorry, guys. Don't mean to be difficult. I'm...

Turning attention to a different media... Anyone remember Captain Carrot and the Zoo Crew?