Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-13 : 21:36:29
|
Henrik writes "I have a problem that I have been working with for some time now, and that is how to efficiently import data from another database.
My problem is this:
I have an ASP page that uses an Access database or MS SQL or another type accessable via ADO.
I want to import data based on rules like "if price lower then import" from an external database (not necessarily the same type).
The solution I use now is that I do a sql query from the import database and then check each row against my database. This results in one sql query's per row and take's alot of time and CPU power.
Work's fine with a few hundred rows but with thousands it's taking too long time.
Is there a solution that don't need to handle each row?
Is there a way to use a recordset with a new sql query?"
|
|
|
|
|
|
Importing data from another database.