TheSQLGuru (8/20/2009)

---

Rowan (8/19/2009)

---

Thanks, I will visit this option, but because I'm drawing data from a DB2 database I will have to see how this can be done.

Just to give you...

Thanks, I will visit this option, but because I'm drawing data from a DB2 database I will have to see how this can be done.

Just to give you an idea,...

Hi Elliot

Delta operation?

Thank Antonio

Yeah seems like a join instead of 'not in' is the way to go

No unfortunately there aren't any null values

Yeah i dunno man, i tried the NOT EXISTS method and it works with your dummy data but not with my actual data.

Maybe its a data thing.

Christopher Stobbs (4/15/2009)

---

oh and here is some sample stuff that I'm using:

CREATE TABLE Table1

(BIBNAC VARCHAR(100),Col1 INT,Col2 INT ,Col3 INT)

CREATE TABLE Table2

(ACCOUNTNUM VARCHAR(100))

CREATE CLUSTERED INDEX PK_1 ON Table1

(BIBNAC)

CREATE CLUSTERED INDEX...

Sorry , I did...

Hi Lynn

I'm not sure...

Lynn Pettis (4/15/2009)

---

Let me throw another monkey into the wrench. Over a year ago we were upgrading our PeopleSoft HR system from version 8.8 to 9.0, and this required...

Hi Lynn

Sorry for the late reply.

Thanks for all the replies

This is just crazy. I'm in the process of migrating my sql 2000 server to a sql 2005 server but...

Thanks Grant i will try that asap

Thanks Lynn, i will try that asap

I did try your query where you use 'except'

This did cut the running time down quite a bit

Lynn Pettis (4/15/2009)

---

Rowan (4/15/2009)

---

Its a Windows Server 2003 server SP2

Microsoft SQL Server...

Its a Windows Server 2003 server SP2

Microsoft SQL Server 2005 - 9.00.4035.00...