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

WayneS (1/19/2016)

---

Eirikur Eiriksson (1/19/2016)

---

Suddenly everythings is so quiet, no notifications or emails blimping on the phone, not a single message since early afternoon, am I lucky or maybe Steve, is...

GilaMonster (1/19/2016)

---

*sigh* All but one comment on a blog post are of the form 'Did you try X?' 'Have you compared Y?' 'Probably should have a test with Z'

*NO. If...

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 faster than my test...

Suddenly everythings is so quiet, no notifications or emails blimping on the phone, not a single message since early afternoon, am I lucky or maybe Steve, is SSC's email service...

Looks just like the waiter (as I remember him/her) when we left the pub the other day:-P

😎

Jason A. Long (1/19/2016)

---

Eirikur Eiriksson (1/18/2016)

---

Nice idea but I see two potential problems, firstly the costly concatenation and substringing with the data type conversion is going to impact the performance...

My apologies for not substantiating my previous posts earlier, slightly busy:-P Just had few minutes to piece together a quick test harness, please feel free to improve and add to...