What are you doing in that package that returns a recordset?

Any of the id columns allow nulls?

Thanx... I'm trying to learn .

Oh and I thaught you were talking about guys standing up when they saw you.

My mitake

you can use this technic to change database if you only want to run a select :

--start script

use Pubs

Select * from jobs

use NorthWind

Select * from Orders

--or the equivalient from...

No I'm a programmer. I wish I could become a DBA someday.

About the stand-up results, we'll need a video to proove that

Can you show the data for those columns in each table?

And how ActualId is related to FundId??

Yes but how do you need this data to be combined with the other rows of the other tables?

What do you expect as a result of the query?

Sorry to shatter your dreams but I'm only a programmer

BTW if the coin is actually rotating (flipping),...

USE DB1

Select * from db2.dbo.TableName T1 inner join dbo.Table2 T2 on T1.id = T2.id

And I thaught that DBAs could do anything. Another dream down the drain .

Depends of what you expect as a result...

Can you send the table definition, some sample data and the expected results of the query.

Sushila, so how's that coin tossing coming along?

Or actually do the right thing and write a few stored procs if you different sets of columns.

Or the best of all, sort client side where it takes a huge...

This is not pretty but it works :

Select SLlastName from dbo.academicoffice A inner join dbo.schoolrequest S on A.AOid in (S.SLsendToId, S.SLbillToId, S.SLrequestorId)

Use isnull(S.SLsendToId), ... if the fields can be...

Or you can check the data before sending it to the proc...