Turned pivot select query into a table

Question

I'm using SQL Server 2014 Management Studio, I adapted the following code from a net:

USE [DRILLHOLES_Export]
GO
     select * from
     (
        SELECT [DHSurveyId],[AttributeColumn],[AttributeValue]
              FROM mytest
     ) A
     PIVOT
     (
       Max(AttributeValue) 
          FOR [AttributeColumn] IN ([Azimuth],[AMG Azimuth],
                               [Dip])
     ) AS PVTTable

I want to save it to a table. Can anyone help. Regards, Peter

Possible duplicate of [How to create a table from select query result in SQL Server 2008](http://stackoverflow.com/questions/16683758/how-to-create-a-table-from-select-query-result-in-sql-server-2008) — Tab Alleman, Dec 29 '15 at 15:46

score 1 · Answer 1 · answered Dec 29 '15 at 05:31

use Create table or select into:

via: select into

     select * into talbe_name from
       ( SELECT [DHSurveyId],[AttributeColumn],[AttributeValue] FROM mytest) A 
          PIVOT(Max(AttributeValue) FOR [AttributeColumn] IN ([Azimuth],
                [AMG Azimuth], [Dip])) AS PVTTable

via: create table

   create table table_name (
     Azimuth varchar(10),
     AMG_Azimuth varchar(10),
     Dip varchar(10)
     );
   insert into table table_name(DHSurveyId,AttributeColumn,AttributeValue)
    select * from 
       ( SELECT [DHSurveyId],[AttributeColumn],[AttributeValue] FROM mytest) A 
          PIVOT(Max(AttributeValue) FOR [AttributeColumn] IN ([Azimuth],
                [AMG Azimuth], [Dip])) AS PVTTable

score 0 · Answer 2 · answered Nov 11 '16 at 14:40

YOU CAN USE INTO CALUSE (After into keyword your new tablename)

 select * into yourtablename from
 (
    SELECT [DHSurveyId],[AttributeColumn],[AttributeValue] FROM mytest
 ) A
 PIVOT
 (
   Max(AttributeValue) 
      FOR [AttributeColumn] IN ([Azimuth],[AMG Azimuth],
                           [Dip])
 ) AS PVTTable

Turned pivot select query into a table

2 Answers2