Have you tried putting a number in the Precision column to represent the maximum, err, precision of the incoming data?

How about something like this?

Create table #TestTable (EmailID Int, EmailAddress Varchar (100))

Insert #TestTable Values (101, 'Donald@Trump.com'), (102, 'Ted@Cruz.com'), (103, 'Hillary@Clinton.com'),

(104, 'Bernie@Sanders.com'), (105, 'Donald@Trump.com'), (106, 'Hillary@Clinton.com'),

(107, 'Donald@Trump.com');

WITH Ordered AS (SELECT...

Eirikur Eiriksson (4/18/2016)

---

Phil Parkin (4/18/2016)

---

Eirikur Eiriksson (4/18/2016)

---

No insight info but have been playing around with 2014 as target server and so far no problem. Note that I've not used any...

Eirikur Eiriksson (4/18/2016)

---

No insight info but have been playing around with 2014 as target server and so far no problem. Note that I've not used any version specific libraries in...

Add a /y...

Why not? Properly written triggers can handle multi-row changes with no problem.

That sounds annoying.

Have you tried sfc and doing a repair install on your VS installation?

Phil Factor (4/18/2016)

---

I used to think it was just me who forgot about triggers I'd written just a short while beforehand. It is just like stepping on a rake in...

Eirikur Eiriksson (4/15/2016)

---

Phil Parkin (4/15/2016)

---

GilaMonster (4/15/2016)

---

I'm going to have to steal "Don't have a clue...

GilaMonster (4/15/2016)

---

I'm going to have to steal "Don't have a clue how to optimize this...

Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!

T.Ashish (4/15/2016)

---

This is generated output. Actual script is like

case when

...

What sort of harm do you have in mind?

You mean this?

richardmgreen1...

Kazmerelda (4/15/2016)

---

Well my query even with the CASE in there is now running in 3 seconds versus 25 so thank you so much for your pointers there.

I will battle...