sql server - How to save select query results within temporary table?

Question

I need to save select query output into temporary table. Then I need to make another select query against this temporary table. Does anybody know how to do it?

I need to make this on SQL Server.

question from:https://stackoverflow.com/questions/4391442/how-to-save-select-query-results-within-temporary-table

Answer 1

select *
into #TempTable
from SomeTale

select *
from #TempTable