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