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 =...

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...

I've added ddl_admin to the people that need to execute this Stored Procedure.

It has worked in testing.

I'll know for sure next week when it's deployed, but it looks good. ...

Also, I use this connection string

"ODBC;Driver={Sql Server};Server=SQLServer;Database=TPrj;Trusted_Connection=Yes" for my Pass-Though queries.

I have read there is a better, more stable, driver.

Can someone point me to one or is this okay?

My bad,

When I said multiple rows I didn't mean data that I could sum.

i.e.

Field_1, Field_2

Main_ID, Data_A

Main_ID, Data_B

Main_ID, Data_C

I would rather

Main_ID, Data_A, Data_B, Data_C.

I usually do this with a Join (or...

Perhaps when I get the calcualtion finished I'll be back for your help.

Honestly it's a bit lengthy and hard to follow just giving you the list of tables.

This does not...

I apoligize everyone,

A little more research and I found it.

But if anyone needs it, here it is:

'Using FETCH to store values in variables'

http://msdn.microsoft.com/en-us/library/ms180152.aspx

USE AdventureWorks2008R2;

GO

-- Declare the variables to store the...