Lynn Pettis (1/20/2016)

---

Brandie Tarvin (1/20/2016)

---

Eirikur Eiriksson (1/20/2016)

---

Alvin Ramard (1/20/2016)

---

Ed Wagner (1/20/2016)

---

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything...

Phil Parkin (1/20/2016)

---

Eirikur Eiriksson (1/20/2016)

---

Grant Fritchey (1/20/2016)

---

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently...

GilaMonster (1/20/2016)

---

Eirikur Eiriksson (1/20/2016)

---

Alvin Ramard (1/20/2016)

---

Ed Wagner (1/20/2016)

---

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long,...

Alan.B (1/20/2016)

---

Eirikur Eiriksson (1/20/2016)

---

Alvin Ramard (1/20/2016)

---

Ed Wagner (1/20/2016)

---

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long,...

Alvin Ramard (1/20/2016)

---

Ed Wagner (1/20/2016)

---

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for this length....

Ed Wagner (1/19/2016)

---

Thanks, Eirikur. Yes, there are many approaches to getting the...

Grant Fritchey (1/20/2016)

---

Sitting in a meeting at Redgate talking about plans for SQL Server Central. THE THREAD has come up as a topic. We are currently a 65mb thread. It...

Ed Wagner (1/20/2016)

---

I love the internals stuff. I'm currently reading SQL Server 2012 Internals by Kalen Delaney. If anyone's looking for good stuff on the internals, it's one...

As I see it Recursion in T-SQL is like paying taxes, something we would all like to avoid but some(read most)times that's not possible.

😎

ROFL (and disabling auto correction)

😎

BTW counting René Goscinny/Albert Uderzo's Asterix will also work.

Steve Jones - SSC Editor (1/20/2016)

---

This is, potentially, the longest thread on the Internet. I'm not sure I've seen anything continue this long, for this length. We were, by far,...

Jacob Wilkins (1/20/2016)

---

Having said that, it looks like using ISNULL with an appropriate minimum value instead of the OR IS NULL brings the performance of the CASE back in line...

Jacob Wilkins (1/20/2016)

---

I agree that using ISNULL would make it read a bit better. My main concern with that was general applicability, particularly, what do you replace NULLs with that...

Jacob Wilkins (1/20/2016)

---

Eirikur Eiriksson (1/19/2016)

---

Jacob Wilkins (1/19/2016)

---

Throwing in the CASE using Eirikur's wonderful setup yielded this on one million rows on my machine (tangentially, I'm embarrassed that Eirikur's laptop is...

below86 (1/20/2016)

---

Eirikur Eiriksson (1/20/2016)

---

below86 (1/20/2016)

---

Just a simple way I would try and get this:

CREATE TABLE #datetest

(

id varchar(8),

L1 date,

L2 date,

L3 date

);

INSERT INTO #datetest (id, L1, L2, L3)...