Can you post the full execution plan? Maybe we'll see something you missed.

Yup, those plans would have been nice to see .

Seriously

put that code on the server

Stored proc :

create...

vb call :

put that cod ein a vb application an run it once. If you have questions, then come...

Any server will load all it can in memory for faster access... The recommanded ram for the server is 1 Gig IIRC. The rest is just data sent...

HTH.

Or for a incredibly more powerfull solution :

IF EXISTS (Select * from dbo.SysObjects where name = 'fnSplit_Set' and XType IN ('FN', 'IF', 'TF'))

DROP FUNCTION dbo.fnSplit_Set

GO

IF EXISTS (Select * from...

Without using in and making sure it can't fail :

select applicantid from aa A

where skillid = 1 and exists (select * from aa B where skillid = 3 and...

Can yu link from the local server to the www server? That way you could put the sp on the local server and execute it from the remote.

That worked before (trimming) .

We're not here to do your homework. This site can help you greatly :

W3Schools - SQL

Where can I get more info on that rudy??

colid is smallint so the theorical limit is 32767 joins .

Please do not cross-post, we monitor all boards.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=224566

Please post the whole select statement.

Do you really stop at 4 joins... isn't this a little short??