Very gothic, reminds me of Reign of Fire.

GilaMonster (9/24/2010)

---

... a dragon...

Gail, 'scuse me for being nosey...but what...

What happens when there's a row in one table but not the other (matching on OrderID)?

Run these two queries and describe the output:

SELECT sc.OrderID, sd.OrderID

FROM supplydates sc

LEFT JOIN supplychaindates...

Paul White NZ (9/24/2010)

---

Yours is the only one to return the new row (item 'D').

As I read the first post, the task is...

:blush: I don't see it Paul...

DROP TABLE #t1

CREATE TABLE #t1

(

...

greg 2201 (9/23/2010)

---

One wouldn't want the average of 20 prices to be represented the same as say 3 prices, but one might very well want the average of 20 seconds...

tt-615680 (9/23/2010)

---

...

I get the same problem when I just run the query by itself.

The whole point of the query is to get all the updated data from the two...

The Dixie Flatline (9/23/2010)

---

select *

from #t1

where item in (select item from #t1 group by item having COUNT(distinct value) > 1)

Talk about your low hanging fruit...

Mine could be just a bit...

What are you expecting to see?

Why are you wrapping these two statements inside a transaction?

What do you see if you remove INTO #UpdatedValue from your first query?

An interview with JBM, "Fastest way to clear a table" 😛

Re-freakin'-breathin' apparatus

DROP TABLE #Sample

CREATE TABLE #Sample ([Policy Key] int, Premium money)

INSERT INTO #Sample ([Policy Key], Premium)

SELECT 123456, 1002.36 UNION ALL

SELECT 123456, 526.25 UNION ALL

SELECT 123456, -1002.36 UNION ALL

SELECT 456789, 256.23...

re-freakin'-fried-beans

No problem.

DROP TABLE #Sample

CREATE TABLE #Sample (Postcode VARCHAR(10), [Source] CHAR(1), Distance INT)

INSERT INTO #Sample (Postcode, [Source], Distance)

SELECT 'HX1 1AA', 'A', 200 UNION ALL

SELECT 'HX1 1AA', 'B', 220 UNION ALL

SELECT 'HX1...

Can you describe the rules for choosing one row over the others?

HX1 1AA,A,200

HX1 1AA,B,220

HX1 1AA,C,100

HX1 1AA,D,120

In this case, you've chosen the row which has the smallest value for distance. Is...