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

User · Answer

In Sqlite   CREATE TABLE T AS SELECT   FROM      -- Use temporary table  T  DROP TABLE T

User · Answer

You can also do the following   CREATE TABLE  TEMPTABLE       Column1 type1      Column2 type2      Column3 type3    INSERT INTO  TEMPTABLE SELECT      SELECT   FROM  TEMPTABLE      DROP TABLE  TEMPTABLE

User · Answer

select   into  TempTable from SomeTale  select   from  TempTable

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

Examples related to sql-server

Examples related to sql-server-2005