It would also allow you to cleanup the global temp table when you're done with your query results.<BR><BR>I don't know that the OPENQUERY () syntax supports compound queries for SQL Server ...