set @SQL = ' select * INTO #TEMP from ( SELECT 5 AS myorder, ''AltModeParticipation'' as Label, [Year], AltModeParticipation FROM HistoricalSummary WHERE CompanyName = @CompanyName ) Table1 pivot (sum(AltModeParticipation) for year in (' + @Columns + ')) p5 ' execute sp_ExecuteSQL @SQL, N'@CompanyName nvarchar(65)', @CompanyName ; <strong>SELECT * FROM #TEMP</strong>MartinaJ
>set @SQL = >' >select * INTO #TEMP from ( > >SELECT 5 AS myorder, >''AltModeParticipation'' as Label, >[Year], >AltModeParticipation >FROM HistoricalSummary >WHERE CompanyName = @CompanyName >) Table1 >pivot (sum(AltModeParticipation) for year in (' + @Columns + ')) p5 ' > >execute sp_ExecuteSQL @SQL, N'@CompanyName nvarchar(65)', @CompanyName ;>