How do I create a table based on a Query Result? 1

[faust13]

My DBMS is MSSQL:

I would like to create a table based on my query results, I don't know how to do it, any help is appreciated.

SELECT Col_A, Col_B, Col_C
FROM myTbl
WHERE someCriteria = unimportant

CREATE TABLE myNewTbl(
newCol_A int,
newCol_B int,
newCol_C int
)

With the query results going into the respective new columns in the new table.

Suggestions? ----------------------------------------
Is George Lucas Kidding...

 

[tlbroadbent]

Use a SELECT INTO query.

SELECT Col_A, Col_B, Col_C
INTO myNewTbl
FROM myTbl
WHERE someCriteria = unimportant Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[rac2]

First create the table.

Then INSERT rows using the query like this

INSERT INTO myNewTbl (newCol_A, newCol_B, newCol_C)
    SELECT   Col_A, Col_B, Col_C
       FROM     myTbl
       WHERE    someCriteria = veryimportant