To Use Pivot Table as View in SQL Server

I have got a pivot table. I prepared it 开发者_开发知识库in SQL. But I cant use this table in View. I using SQL Server 2008.

---

See this answer to a somewhat related question:

sql-pivoted-table-is-read-only-and-cells-cant-be-edited

You need to make the view updateable via an INSTEAD OF trigger, and there are specific conditions to using that trigger, such as the pivot-table view being fully identifiable to source record-column.