Hi Remi

What is a listview?

Paul

Thanks Noel

I'll check these out.  I need to get a good grip on this.

Thanks again for your time and trouble.

Paul

Thanks, Noel

Sorry for the delay - I've only just had the chance to get back to this.

When tables are linked, does this provide a load on the individual PC connection...

Absolutely brilliant!

Thanks very much for this.  It's exactly what I want.

Sorry for late reply - I've only just had the chance to get back to this.

Many thanks again

Paul

Hi Hans

I couldn't agree more.  I just wanted to make sure I had explored every possibility my end before tackling the software vendors.  I've also learned quite a lot.

Many thanks...

Hi Hans

I've just had the opportunity to try this.  Unfortunately there was no real improvement.

Thanks for trying.

Paul

Thanks, Hans

I'll give this a try and get back to you.

Thanks again

Paul

Thanks again Remi

I think that is a good idea.  However, futher support issues preclude the working of SPs on the Oracle server.  I am going to have to make it...

Hi Remi

I've made some changes to protect the innocent, but the flavour remains the same.  #STY1 is a temp table which is used on the SQL Server to update a...

Remi, thanks for all your help - I really appreciate the time you've put in.

Hans, are you saying the Select is undertaken by the Oracle server rather that the SQL...

Hi Remi

Will do.  I'm not so bothered about the SQL Server having to work - I've got lots of spare capacity, its just that I want to ensure that the...

Hi again

I've been playing around with the SQL and really just substituted a series of chosen dates for a BETWEEN two dates.  It still gives me what I want.

Originally (I have just noticed)...

I'll do my best to get this down to around 3k?

Many thanks for your time and trouble with this - it is much appreciated.

Paul

One Select shows the Remote Query is 26% and the row count is 10k.  The other Select shows Remote Query as 0%.

What do you think?  Is 26% excesive?  If so,...

Hi Remi

When I try to run an Execution Plan it returns:

Server: Msg 208, Level 16, State 1, Line 4

Invalid object name '#CMA'

Can't you do this when the SQL produces temporary...