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?

Lowell (4/7/2011)

---

If you get a chance, can you explain why you couldn't update from a sub select of that FOR XML method? I know i can do a simple update...

Stupid question. Does COALESCE *have* to use a variable in order to work correctly?

I'm trying a basic SELECT statement where I've replaced the variable with the column name. It's not...

Craig,

If you still need assistance, what's the problem with the problem number?

I'd go for the error table & email, if I had time to work it. But if you don't,...

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 who needed permissions:

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/%5B/url%5D

Lowell:...

Stefan Krzywicki (4/6/2011)

---

Brandie Tarvin (4/6/2011)

---

Stefan Krzywicki (4/6/2011)

---

I remember watching both The Monkeys and Original Star Trek as a kid, but they were both in reruns at that point. And I...

I heard Disney was doing G-Force and got all excited.

Then I found out it was about guinea pigs and...

Barney the purple dinosaur

Non sequitur. I wrote my first web comic. It was put up this morning as a guest comic at Complex Actions. My sister did the artwork.

http://www.complexactions.com/archive/G03.shtml

I hope you all enjoy...