How can I create a temp table and insert data from a query easily?
I'd like to insert data from a query into a temp table in the simplest manner. I've looked at INSERT INTO SELECT, but it looks like the source data has to be from a table. There's got to be a way to do this without cursors, right? Thanks!