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