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 <db1>..<tablename1>, <db2>..<tablename2> ... but of course one need to have the proper grants in all databases in order to do this. -----Original Message----- From: Robert Twitty To: Gerardo Rojas Cc: Svensson, B.A.T. (HKG); php-windows@xxxxxxxxxxxxx Sent: 12-3-2004 20:17 Subject: RE: MSSQL inserting into a table with a valid result set Hi Gerardo If I understand you correctly, you can use the odbtp extension to do something like the following: -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php