Can you post a script to create the tables and some sample data along with the required results.  Maybe there's a better way but I can't sese one at the...

Can you post the actual query?  Maybe we can figure something out with derived table or cte or??

I'd be curious to see a test of this :

1 M rows table :

Select * FROM 1MTbl WHERE SomeCol NOT IN (SELECT 995000 Rows from OtherBigAsstbl)

I'd be curious...

Lol Jeff.  So true for the team part.  I'll let you do the work and I'll make the money.  How's that for teamwork .

BTW...

I can't figure out a straight select way to do this.  The closest I can come with is like you said :

DECLARE @demo TABLE (ID INT NOT NULL IDENTITY(1,1),...

It's not really redundant.  Sql server and ado are 2 different things operating in 2 different environement... and to call a procedure you need to tell the name, the parameters...

Management studio to develop. Maybe the users will need the connectivity tools installed but you'll have to confirm this one.

I think you'll be set by then.

What will you be developping??

I'd like to do this for you but I don't have time... so here's a working sample code from one of my programs :

Private Function exec_GetStartUpForm(ByVal FkADP As Integer,...

You know that results change from PC to PC in that kind of test... and since you already have them printed on your screen, I think it's a farely easy...

You can tell him up front... he's not gonna mind.

JEFF YOU SCREWED UP!

.

Results please?

Thanks.

But that's actually pretty all you can do.  You can always do select * from both tables and manually do the joins... but there comes a point where you just...

Thanks. I meant the code of the stored proc on the sql server.

I'd like to run some test on my pc... can you send me the proc (at least the header so that I know what to work with)?