sp_addlinkedserver creates linked server.

If successfull it means that server is running.

Falure can be cauesed by many reasons.

Server not running can be the reason.

Please read BOL.

Regards,

K. Matsumura

sp_addlinkedserver

returns

0 (success) or 1 (failure)

K. Matsumura

Thank you, David, for your interesting idea.

But I would have to change all object names in the original function.

I mean I have to add [192.168.1.1].MyDatabase.

It would be to difficult for...

Thanks, Jeff.

I will do without UDF.

Thanks, Jeff.

Does that mean a UDF cannot be called from a linked server?

INSERT INTO #Temp1 (OID, ODATE, OOWNER)

SELECT O_ID,O_DATE,O_OWNER

FROM OData

I don' think you can UNION an ORDER BYed statement, right?

K. Matsumura

Maybe this is better

SELECT A.Address, B.accountname, B.emailaddress1, C.Companyname, C.emailaddress1, D.Fullname, D.emailaddress1

FROM #T A

LEFT OUTER JOIN Accountbase B ON B.emailaddress1 = A.Address

LEFT OUTER JOIN Leadbase C ON C.emailaddress1 = A.Address

LEFT OUTER...

I'm assuming it is SQL 2000.(no CTE

SELECT A.Address, C = COUNT(*) INTO #T FROM

(

SELECT Name = accountname, Address = emailaddress1 FROM Accountbase

UNION ALL SELECT Companyname, emailaddress1 FROM Leadbase

UNION ALL SELECT...

Can you post DDL and sample data?

I run the same test using actual table and got following results:

1 time

NOT IN() : 436ms

AND : 390ms

OUTER JOIN: 360ms

NOT EXISTS: 343ms

10 times

NOT IN() : 3,936ms

AND : 3,923ms

OUTER...

I run same test against 1,000,000 records and got following results:

1 time

NOT IN() : 390ms

AND : 373ms

OUTER JOIN: 1,876ms

NOT EXISTS: ...

Another Correction

SELECT *

FROM TableA A

INNER JOIN TableB B ON B.Z_Id = A.Z_Id

AND B.Date = (SELECT MIN(Z.Date) FROM TableB Z WHERE Z.Z_Id = A.Z_Id AND Z.Date >= A.Date)

K. Matsumura

Correction

SELECT *

FROM TableA A

INNER JOIN TableB B ON B.Z_Id = A.Z_Id

AND B.Date = (SELECT MIN(Z.Date) FROM TableB Z WHERE B.Date >= A.Date)

K. Matsumura

Try

SELECT *

FROM TableA A

INNER JOIN TableB B ON B.Z_Id = A.Z_Id

AND B.Date = (SELECT MIN(Z.Date) FROM TableB Z WHERE B.Date > A.Date)

K. Matsumura