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); php-windows@xxxxxxxxxxxxx Sent: 12-3-2004 19:30 Subject: RE: 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: grojas@xxxxxxxxxxxxxxxx -----Original Message----- From: Svensson, B.A.T. (HKG) [mailto:B.A.T.Svensson@xxxxxxx] Sent: Friday, March 12, 2004 12:26 PM To: php-windows@xxxxxxxxxxxxx Subject: RE: 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: grojas@xxxxxxxxxxxxxxxx > > > -----Original Message----- > From: Svensson, B.A.T. (HKG) [mailto:B.A.T.Svensson@xxxxxxx] > Sent: Thursday, March 11, 2004 3:25 PM > To: 'php-windows@xxxxxxxxxxxxx ' > Subject: RE: 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: php-windows@xxxxxxxxxxxxx > Sent: 11-3-2004 21:54 > Subject: 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: grojas@xxxxxxxxxxxxxxxx > > -- > 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
