Create a table on the SQL server with the data from an SQL query?

Question

Is it possible to create a table on the SQL Server with the data from an SQL query?

I am trying to make a data filter screen in an SQL database and I want to try to filter a result that has already been filtered before

If you help me with an example I appreciate.

Does this answer your question? [How to create a table from select query result in SQL Server 2008](https://stackoverflow.com/questions/16683758/how-to-create-a-table-from-select-query-result-in-sql-server-2008) — Dale K, May 03 '21 at 20:01

score 1 · Accepted Answer · answered May 03 '21 at 17:29

1

In SQL Server you use select into. You can phrase this as:

select . . .
into <tablename>
. . . rest of query here;

Most other databases use create table as:

create table <tablename< as
    select . . .
    . . .;

answered May 03 '21 at 17:29

Gordon Linoff

score 0 · Answer 2 · answered May 03 '21 at 17:29

0

Yes you can create a table using the result of a query very easily using into

select <columns> into NewTableName from <query>

answered May 03 '21 at 17:29

Stu

2 Answers2