How to create view in sql using pivot method

See more:

SQL

SQL-Server

SQL-Server-2008R2

How to create view in sql using pivot method. My query attached here .

DECLARE @cols AS NVARCHAR(MAX),
@query AS NVARCHAR(MAX)
select @cols =STUFF((SELECT distinct ',' + QUOTENAME(os)
from System_mac
FOR XML PATH(''), TYPE
).value('.', 'NVARCHAR(MAX)')
,1,1,'')

set @query = 'SELECT *
from
(
select * from systemos
) x
pivot
(
sum(oscount) for os in(' + @cols + ')
) p '
execute sp_executesql @query;