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...

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 think they were for...

Grant Fritchey (4/6/2011)

---

Brandie Tarvin (4/6/2011)

---

Grant Fritchey (4/5/2011)

---

Brandie Tarvin (4/5/2011)

---

Grant Fritchey (4/5/2011)

---

Whoa! What? You're a youngster and you don't live in a cave, how is it that an old <insert inappropriate...

Grant Fritchey (4/5/2011)

---

Brandie Tarvin (4/5/2011)

---

Grant Fritchey (4/5/2011)

---

Whoa! What? You're a youngster and you don't live in a cave, how is it that an old <insert inappropriate term here> like myself...

Now that's a clever solution. I like the use of Rank, Partition, and Right there.

Grant Fritchey (4/5/2011)

---

Whoa! What? You're a youngster and you don't live in a cave, how is it that an old <insert inappropriate term here> like myself knows what rickrolling is?...

GSquared (4/5/2011)

---

Jack Corbett (4/4/2011)

---

Definitely depends on region AND size of the company. ...

Stefan Krzywicki (4/4/2011)

---

Steve Jones - SSC Editor (4/4/2011)

---

Do you know what shrinkage is, from a data standpoint? Or is that where you are looking for guidance?

Once you define it, then...