Good question and great followup. Thanks for a good one, Andy.

Jack Corbett (5/21/2014)

---

TomThomson (5/20/2014)...

But I probably ought not to say such things - after all, most of the audience here are US citizens who regard anything done and...

crookj (5/20/2014)

---

eccentricDBA (5/20/2014)

---

Ed Wagner (5/16/2014)

---

History (I know what you mean. I love playing strategy board games like History of the...

While...

Yeah, I saw that. If it isn't a scam, it sounds like it would be a full time job.

If I'm reading it correctly, is this what you're after?

select a.id,

case when a.name = b.name then '' else 'name' end name,

case...

I don't see an authorized date column in your table, but if you want to exclude anything that hasn't been authorized, simply use a where clause to exclude the unauthorized...

This one was posted early. It made me do some research, so thanks for the question.

Sean Lange (5/16/2014)

---

alicesql (5/16/2014)

---

Thanks to everyone who took the time to help me with this. Sean, your comment about looking at columns instead of rows gave me a bit of...

History (I know what you mean. I love playing strategy board games like History of the World, Axis and Allies,...

Board Game

Axis

I appreciate that you're relatively new at this, as we were all there at one point or another. Sean hit the nail on the head. The CTE is...

When you try to delete from the child table, are you sure the referential integrity error is with the parent table? It could be that the child table has...

Attitude