One can also do cross queries between database instances in
the same MS SQL server (but I don't think this was the case
in this case?). Anyhow, if a result set has been fetched from
the same MS SQL server, then one alternatively can do like this:
SELECT ...
FROM .., ..
...
but of course one need
You can a) spool your result set to a tab delimited file and
bulk load (should be the fastest way), or b) use the same file
and use bulk insert, or c) insert the result set "manually"
with php into some table that you either create on the fly
or already have availabe in the target database, etc, et
You can do a insert into with a SELECT instead of VALUE,
but the attribute in the select must agree with the table
definition.
-Original Message-
From: Gerardo Rojas
To: [EMAIL PROTECTED]
Sent: 11-3-2004 21:54
Subject: [PHP-WIN] MSSQL inserting into a table with a valid result set
I hav