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.< ...

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 ...

If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL ...

A more SQL-compatible way of doing things is to load each of ... column called tempId (the # at the start of the table name flags the table as temporary): Create Table #tempIds (tmpId nvarchar(20) ...