您应该可以使用INTO子句。我在您的示例中添加了INTO。
SET @cols = STUFF((SELECt distinct ',' + QUOTENAME(QT.QUESTION_DESC) FROM #QUES_TEMP QT GROUP BY QT.QUESTION_DESC FOR XML PATH(''), TYPE ).value('.', 'NVARCHAr(MAX)') ,1,1,'')set @query = 'SELECt eval_ID, AuditType, ' + @cols + ' from ( select QT.eval_ID, QT.AuditType, QT.SCORE, QT.QUESTION_DESC into ##tmp from #QUES_TEMP QT ) x pivot ( max(SCORE) for QUESTION_DESC in (' + @cols + ') ) p 'execute(@query);SELECt * FROM ##tmp
