Does anyone know of one?

Tim C.

//Will write code for food

Hmmm, using the Command object does not mean you are not recieving results. If you use :

 

'no records, make sure to use the adExecuteNoRecords if...

I would suggest if doing it in a DTS package to use a VBScript step with the Scripting.FileSystemObject. There are MANY examples of doing what you asked for on Microsofts...

This doesnt say don't do it, but in there it does warn against using 4 or more joins, plus it has a couple other good join tips :

http://www.sql-server-performance.com/tuning_joins.asp

Tim C.

//Will write...

I would have to venture it would also depend on the data types joined, and how wide the tables were, and indexes, etc.....

Tim C.

//Will write code for food

I highly recommend this product SQL Compare from red-gate. Read a review from Andy Warren here : http://www.sqlservercentral.com/columnists/awarren/reviewofsqlcomparisonandsynchronizationtoolkit.asp His review is a coupld versions behind, but it has only gotten...

Another thing you can do from ADO, if you don't mind doing dirty reads is set

the IsolationLevel on your connection object to adXactReadUncommitted, then call

BeginTrans on your object....

quote:

---

We use stored procedures for everything else, including data retrieval. The can

do everything a view can do and faster.

---