No experience here. However we do use both SQL Server en Lotus Notes in our company.

I would use the ODBC driver for Lotus Notes. This gives you relatively easy access...

Extend the procedure from Antares in your previous thread "parsing a column to replace all commas with spaces".

Add an cursor in the loop :

SELECT id FROM sysobjects where type='U'

--Returns the...

There are a lot of similar threads around. Try the search for 'Search Engine'. This should give you a fair amount of information.

How do you enforce the RI? Do you use the cascading delete options in SQLServer, do you have a bunch of triggers on the tables or is your app making...

To my knowledge, you cannot call a stored procedure inside an UDF. Only extended stored procedures are allowed within a UDF.

What is done in the 'cursor loop' approach, is getting a recordset and stepping through the recordset, one record at a time.

In general this is discouraged because it eats up...

Like the idea of Andy. We have implemented it in a very similar way. Only three changes :

We put in an additional level : Group. Makes life (and administration) a...

Maybe a bit less crude.

Use profiler to log all SP:Starting events for some time.

You can write to table or import the file later on, and do a 'simple' join on...

I would never use the second notation, since it looks a bit obscure to me.

But then again, your question was about the performance, so it set me thinking. What would...

The error is caused by the insert statement in the _CUSTOMER_ table. It reads :

PHONE = dbo.USPHONE(PHONE)

You forgot the @ ...

Have you installed all SPs, both on the server and on the client.

Don't forget the MDAC SP on the client, if it's not installed by Office SPs.

This could be due...

I would opt for a single table, if its just some configuration or description stuff. E.g. filling a combobox for filtering the resultset.

But when you will store the value of...

Just to add to GRN's reply ...

When you execute the procedure, you should also specify the parameters as OUTPUT. A correct call could be :

DECLARE @PL_Amt decimal(15,2)

DECLARE @ContractCount int

DECLARE @MinDate...

The syntax is

UPDATE EC_D_DOC SET

DateDoc = E.DateDoc,

....

FROM EXPORT E

WHERE EC_D_DOC.DocRef = E.Document_ID

This should do the trick. However, you should take care that the (select) query only returns a single row for each cc_nbr.

UPDATE FDE_TRANHISTORY SET LAST_STMNT_DATE = temp.LastStatementDate,

LAST_SUMMARY_DATE = temp.LastAccountSummary

FROM

(SELECT...