Thank you,

That worked great. We haven't upgraded yet but are close. I'm I'll make comments in my sp, Thank you again.

Sucess!!!!

Thank you,

Now I have to work out the particulars, i.e. the actual parameters to pass.

Thank you again.

I got a slimmed down version to work using EXECUTE sp_executesql.

However, I have more that 4,000 characters in the Select and...

This version of SQL Server has a 4,000 character max...

Yep, DTC is running.

If

A) Select From OpenQuery

And

B) Execute ('string') with string = 'Select From OpenQuery'

And

C) Insert Select From OpenQuery

All work

Then why doesn't

D) Insert Execute ('string')

Or Even

E) Insert Execute Stored Procedure

Work?

Actually,

I use 'Where' statements in OpenQuerys to the database often. Often in the statements I willl going multiple [linked] tables with each having their own 'Where'.

And I use these...

No go!

This works fine:

create table #T (Col1 int, Col2 int);

insert into #T (Col1, Col2)

My script that returns two columns;

select *

from MyTable

I also tested the following just to see if the...

Can you elaborate?

I'm not sure what you mean and you I would do the Left Join .... On ...

yep,

Good idea though

P.S. I've tried:

execute sp_helplinkedsrvlogin @rmtsrvname='My_Test'

Seems to work

Execute sp_tables 'My_Test'

Seems to work but no records are returned

Both of the following get the error in the above post.

Execute sp_columns_ex 'My_Test','tbl_Transactions'

Select *...

I've been following the directions. Even checked on MSDN and I still can't get in.

Here is the code:

EXEC sp_addlinkedserver

@server = N'My_Test'

, @provider = N'Microsoft.Jet.OLEDB.4.0'

, @srvproduct = N'OLE DB...

Michael, that function worked great.

Thank you,

I'm new to functions so I need to learn them. But this one did the trick.

Thanks again.

Fantastic.

I can make this work.

So, no "(" and use 'Case'

That was I can set variables, manipulate them and when I get to the result.

I didn't realize setting a variable was...

I don't believe Case will allow me to do what I need.

As I said there will be many (100 plus) variables which some may or may not be used depending...

I can't believe I just made that simple of a mistake.

Thanks, just proves that when you look at something long enough you can't even see your own typos.

Sorry for the...