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

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)

VALUES ('1005', '1-1-16',...

Quick thought, hard to get this wrong as one can almost count anything

😎

USE tempdb;

GO

SET NOCOUNT ON;

--http://www.sqlservercentral.com/Forums/Topic1753771-3411-1.aspx

DECLARE @SAMPLE_SIZE INT = 100;

DECLARE @BASE_DATE DATE...

If the true value is repeated, regardless of what extra characters are in the...

rarara (1/20/2016)

---

Snapshot creation which is used to populate an MI database. This snapshot is then dropped after the export completes.

Maxdop is changed as the performance of the MI population...

Quick question, how are you going to handle the duplicate values?

😎

The easiest solution is to dedupe the set before the update.

aaron.reese (1/19/2016)

---

@jacob and @jeff

SSRS is not my natural home 😀 so I was not aware that IIF(x AND y) is a bitwise operation. Maybe I wasn't asking google the...

Don't think that would...

Jeff Moden (1/19/2016)

---

Heh... every...