I'm definitely going with a Server OLEDB is fast and a Liked server to a remote server can be terribly slow.

Thanks

Yes, I'm running SQL Server 2008 R2 64 bit on Windows 2008 R2 64 bit.

I believe that you are right that I will need both 32 & 64 bit clients.

Hey Lowell,

Thanks a lot.

Now I'm trying to remember which Oracle Download that I need. The Client Drivers only, etc?

I'm not sure and I would prefer to download the correct on...

No need to reply to this thead, thank you.

It is exactly the same. Positively.

It is a Simple Query. I just wanted to get the record counts right before I added a bunch of CASE Statements.

As soon as I add the first LEFT JOIN...

The person who normally works with this data is going to complete the UPDATEs one at a time so I'm off the hook but a bit baffled.

Thanks.

If I comment out the LEFT JOIN's I get 39,028 Records.

With the LEFT JOIN's uncommented I get 26,0876 records.

I do not intend to use a WHERE Clause is ths scenario.

After I got the record COUNT correct I was going to incorporate an INSERT INTO with CASE Statments on...

I'm trying to get all the records from the History Table (39,026) but after I join I get only 26,086.

What is wrong with my statement and how can I get...

I don't know what I was thinking on the CASE UPDATEs.:blush: dah.

I figured out how to solve the problem.

The first step is to INSERT records from another into a Table.

If...

Unfortunately I'm unable to duplicate the problem and it is just a simple UPDATE Statement.

The Data originated from an old AS400 Legacy System.

I was asked for help from the former...

I tried that and I encountered something very strange.

I perform...

I have almost 200 Columns that I have to update,

I just checked and none of the CASE Statements are updating all of the records.

Does anyone have an example of a Sercehed CASE Statement used to perform UPDATES.

One that works.:hehe: