Isn't this

(s.credit IS NULL AND b.status = 'OUT' AND b.boxid NOT IN (select boxid from USFPIMS..box)

AND

...

You cannot execute stored procedures from within UDFs, and sp_executesql is a stored procedure.

You have to find other way to do your task, it seems.

Piotr

What is the type of tstamp column?

Piotr

This is in fact interesting. I created a DDL trigger for database create/alter/drop events.

create trigger trigddl

on all server

for CREATE_DATABASE, DROP_DATABASE, ALTER_DATABASE

as

SELECT EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)')

It is triggered with no probs when I...

The reason is that Excel is using double datatype which is exactly same as float in SQL Server.

Piotr

Some numbers cannot be stored with infinite precision in computers because computers in the end store only 0s and 1s. Some datatypes are more precise than others, but never 100%...

right :Whistling:

Look at the PIVOT command in BOL, this should do the job.

Piotr

I had some problems with moving data the other way, from Sybase. It turned out to be driver issue. Took at these tables and try to find out what are...

if there are no inserts, maybe the database can be set read only?

Sorry for the question, but have you checked that the firewall doesn't stand in the way?

Piotr

You can open MS Access, create new database and link two tables - one from excel spreadsheet and one from SQL Server.

then you can create new query and run update...

You can name the linked server whatever you like in GUI also:

in Linked server enter name you want to use

in Provider select SQL Native Client

in Data source enter server machine...

Hm.. according to BOL you cannot create a synonym for database, only for objects existing in database (roughly speaking)

Synonyms can be created for the following types of objects:

Assembly (CLR) Stored...

Can you post the connection string you use?

You can force client to use given protocol in connection string by prefixing server name with tcp: or np:

Piotr