Yes Gail...

Updating the stats worked and the query ran in just a few seconds. Sigh...

So my next question is should I / can I modify the Stored Procedure...

Thank you yet again.

This upgrade is going considerably smoother with your help,

I hope I'm able to return the favor...

I have no doubt the SQL may be questionable since I'm still fairly new.

So in addition to that you're saying that SQL 2005 may run somewhat slower on some queries....

Thank you for your help but, of course, I have a new questions.

I believe the admin ran the Update Stats, yesterday and everything seemed to work. I have another...

Bingo,

I spoke to the admin. He just ran update statistics (and some other thing???) and yeah!!! It worked.

Thank you,

Now we'll have to schedule the other db's and run the...

I'm not sure I follow.

Pay_Type_ID is a two letter code; PR_Status is a one letter code. I can change PR_Status from nchar(1) to nvarchar(1) and oddly enough it executes.

I wonder why it works when I change the nchar(1) to nvarchar(1)

I'll pass that along,

Also something I noticed. Looking at the Where the second on 'PR_STATUS' is a data type "nchar(1)".

All of the 'Pay_Type_ID's are nvarchar(2). When I deleted...

I didn't do the upgrade... But I'm guessing no.

Will that impact the Where will doing a comparison?

How do you do an update to statistics so I can direct him in...

Wow, what a great idea!

I never actually thought of that; I could down load a data set limited to what I need and it would speed things up.

Thank you,

I'm updating the local table.

My first thought was replacing the view with an OpenQuery within the SP. Narrowed down the amount of data but didn't solve the problem.

I did...

thank you for your help everyone,

I appreciate it.

Not, we should be good there.

I'll test the ADO connections but so far it looks fine.

Code issues is one of my main concerns. But we've tested most stored procedures against out test environment.

Can you give me a common example of a OLDB issue or problem?

Yes we know and it has come up in discussion; the good news is that it's not my decision.