Additionally, I want to run some additional queries off of that data that is returned from the SQL Server. I have concluded that the easiest way may be to create a temporary table that I can ...

I tried this in the past, but didn't have any luck.<BR><BR>Is it possible to create a temp table on a remote server?<BR><BR>Situation:<BR><BR>I have to run a group of queries against a remote server.< ...

Microsoft SQL Server, Oracle and PostgreSQL all support recursive queries using CTEs. Note that Oracle also offers an alternative syntax using the CONNECT BY construct, which we will not discuss here.

SQL Server 2008 provides a minimal set of tools ... All requests to the cursor are answered from this temporary table in tempdb; therefore, modifications made to base tables are not reflected ...

Despite these minor drawbacks, I definitely recommend exploring the table parameter feature when SQL Server 2008 comes out. Tim Chapman is a SQL Server database administrator who works for a bank ...