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, etc.
-----Original Message----- From: Gerardo Rojas To: Svensson, B.A.T. (HKG); [EMAIL PROTECTED] Sent: 12-3-2004 19:30 Subject: RE: [PHP-WIN] MSSQL inserting into a table with a valid result set According to your last email, i can accomplish my goal, by doing: insert into tablename select xxxxx where xxxx is another table i presume. I don't have another table, all I have is a valid $result from running a query. I see what you mean, the thing is that one query is from 1 remote db and the second query (insert command) is on another remote db. -- Gerardo S. Rojas mailto: [EMAIL PROTECTED] -----Original Message----- From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED] Sent: Friday, March 12, 2004 12:26 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-WIN] MSSQL inserting into a table with a valid result set I don't understand your question. On Fri, 2004-03-12 at 16:42, Gerardo Rojas wrote: > Can i do a select from a PHP: resource (positive MSSQL result identifier) > > > -- > Gerardo S. Rojas > mailto: [EMAIL PROTECTED] > > > -----Original Message----- > From: Svensson, B.A.T. (HKG) [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 11, 2004 3:25 PM > To: '[EMAIL PROTECTED] ' > Subject: RE: [PHP-WIN] MSSQL inserting into a table with a valid result > set > > > 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 have a valid result set from running a simple query. Is there a way > of inserting this into an existing table or creating a new table with > the result set? All ideas are welcome! > > MSSQL Server 2000 > PHP 4.3.4 > Windows 2000 pro > IIS 5.0 > > > -- > Gerardo S. Rojas > mailto: [EMAIL PROTECTED] > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
