RE: [PHP-WIN] MSSQL inserting into a table with a valid result se t

2004-03-13 Thread Svensson, B.A.T. (HKG)
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

RE: [PHP-WIN] MSSQL inserting into a table with a valid result se t

2004-03-12 Thread Svensson, B.A.T. (HKG)
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

RE: [PHP-WIN] MSSQL inserting into a table with a valid result se t

2004-03-11 Thread Svensson, B.A.T. (HKG)
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