Use pivot table as a view in SQL Server

Question

I have a pivot table. I prepared it in SQL. But I can not use this table in a view. I am using SQL Server 2008.

Answer 1

See this answer to a somewhat related question:

sql-pivoted-table-is-read-only-and-cells-can not-edit

You need to make the view updatable using the INSTEAD OF trigger, and there are special conditions for using this trigger, such as a pivot table view that is fully identifiable with the original record column.