Insert result set from UNPIVOT into table

Question

I am trying to find the syntax for inserting the results from an UNPIVOT statement into an existing table in the database?

If you are using `Oracle` you could consider using `INSERT ALL` like [here](https://stackoverflow.com/a/50785949/5070879) instead of `UNPIVOT`. — Lukasz Szozda, Jun 10 '18 at 16:54

Rich Andrews · Accepted Answer · 2011-01-05T15:53:16.110

2

simplest answer which works for any SELECT including UNPIVOT would be...

INSERT INTO MyTable
SELECT statement

However, this does require that your destination tables columns match your SELECT statement columns.

Although you can get around this limitation with...

INSERT INTO MyTable (column1, column2....)
SELECT statement

edited Jan 05 '11 at 15:53

answered Jan 04 '11 at 12:49

Rich Andrews

1 Answers1