I was expecting to see two columns of float numbers. You may get some clues from this:

CREATE TABLE #Temp (Float1 FLOAT(1), Float24 FLOAT(24), Float53 FLOAT(53))

INSERT INTO #Temp (Float1, Float24,...

Can you show a few? Please?

The two float values. Check if they are the same.

Run this query:

-- Secondly, test what the update is going to do before you run it,...

Check the two float values in...

Have you run the query I posted, labelled "test what the update is going to do before you run it"?

What does it return?

Check that the datatypes are the same in both tables.

What are the datatypes of those two columns in both tables?

pk2dpvp (6/11/2014)

---

I have this script in my database, but it always gives 2054 rows back and if I actually DO change something it doesn't even notice...

what am I doing...

Using TOP to choke the result set can dramatically change the execution plan whether or not...

Jeff Moden (6/6/2014)

---

ChrisM@Work (6/6/2014)

---

julian.fletcher (6/6/2014)

---

.. I should have said that we're looking for developers to work on all parts of a particular product; both the C# and the SQL. We're...

BWFC (6/9/2014)

---

ChrisM@Work (6/9/2014)

---

BWFC (6/9/2014)

---

ChrisM@Work (6/9/2014)

---

BWFC (6/9/2014)

---

ChrisM@Work (6/9/2014)

---

Is there any chance that your original query - the one with the error - had a filter for the comma in the WHERE...

BWFC (6/9/2014)

---

ChrisM@Work (6/9/2014)

---

BWFC (6/9/2014)

---

ChrisM@Work (6/9/2014)

---

Is there any chance that your original query - the one with the error - had a filter for the comma in the WHERE clause? If...

BWFC (6/9/2014)

---

ChrisM@Work (6/9/2014)

---

Is there any chance that your original query - the one with the error - had a filter for the comma in the WHERE clause? If you can...

Is there any chance that your original query - the one with the error - had a filter for the comma in the WHERE clause? If you can answer "Yes",...

WITH Cases AS (

SELECT * FROM (VALUES

('SystemA', 'Case1', '2013-07-11 13:17:09.000', '2013-07-15 12:05:03.000'),

('SystemA', 'Case2', '2013-07-12 16:27:50.000', '2013-07-12 16:29:12.000'),

('SystemA', 'Case3', '2013-07-12 17:30:32.000', '2013-07-12 17:40:11.000'),

('SystemA', 'Case4', '2013-07-12 19:00:24.000', '2013-07-12 19:04:14.000'),

('SystemA', 'Case5', '2013-10-01...