Roy Ernest (12/3/2010)

---

On another note, WayneS gave a wonderful presentation for our User group yesterday evening. It was well presented and everyone liked it. There were some technical issues from...

Chris Morris-439714 (12/3/2010)

---

CirquedeSQLeil (12/2/2010)

---

I...

Chris Morris-439714 (12/3/2010)

---

Hi Wayne, no I've...

I'm glad it's working for you.

That would be quite cool!

I like to have background classic rock playing softly as white noise.

Occasionally, I'll use classical or upbeat jazz.

I got this sweet little bit of delightful SQL code from MVP Jeff Moden:

DECLARE @test-2 TABLE (ID INT PRIMARY KEY CLUSTERED);

INSERT INTO @test-2

SELECT 74 UNION ALL

SELECT 75 UNION ALL

SELECT 80...

And how is it working?

Great!

Yep, posting actual code that folks can cut-and-paste into SSMS greatly increases...

Grant Fritchey (12/2/2010)

---

Craig Farrell (12/2/2010)

---

SQLNW (12/2/2010)

---

Thank you Wayne, I am thinking why do we use temp table in the first place? As soon as you see a problem how you...

Like this:

DECLARE @test-2 TABLE (RowID INT IDENTITY,

Col1 varchar(100));

INSERT INTO...

Good news indeed.

Just to be sure I understand, you replaced the NOT EXISTS (...) with the LEFT JOIN WHERE column IS NULL, correct? I thought that was what you had...

mtillman-921105 (12/2/2010)

---

Note to self... If tempted to suggest that someone read an article about x, make sure said someone has not actually written an article about x themselves. ...

Thanks for the feedback Frank. So, what is the performance like now on that query that used to run in hours?

Jeff Moden (12/2/2010)

---

Thanks Steve but the real thanks goes to you. You had a wonderful idea...