DECLARE @Year nvarchar(max)='[2008],[2009],[2010],[2011],[2012],[2013],[2014],[2015],[2016],[2017],[2018],[2019],[2020]'
DECLARE @QUery nvarchar(max)='SELECT * FROM ( SELECT salesEXE,SalesEXEName,name,gross,YearNo FROM vw_Pivot_Month_ALL) TableYearNo
pivot (Sum(gross) for YearNo in ('+@Year+')
)pivotTable'
EXECUTE sp_executesql @QUery