PIVOT in view

USE InsideTSQL2008;
SELECT custid, [2006], [2007],[2008]
FROM 
    (SELECT     YEAR(orderdate) AS anno, custid, freight
FROM         Sales.Orders
     ) 
    AS SourceTab

PIVOT 
( 
    sum(freight) 
FOR 
[anno] 
    IN ( [2006], [2007],[2008]) 

) AS pivotTab 

ORDER BY custid;
GO

SELECT DISTINCT '],[' + ltrim(str(_year))FROM  Products
                        ORDER BY '],[' + ltrim(str(YEAR(_year)))
                        FOR XML PATH('')
            ), 1, 2, '') + ']'

DECLARE @years VARCHAR(2000)
SELECT  @years = STUFF((SELECT DISTINCT '],[' + ltrim(str(_year))FROM  Products
                        ORDER BY '],[' + ltrim(str(YEAR(_year)))
                        FOR XML PATH('')
            ), 1, 2, '') + ']'