Crear Cursor en un Pivot Dinamico

declare
@columns nvarchar(MAX),
@sql nvarchar(MAX)

SET @columns = STUFF((
SELECT ',' + QUOTENAME(campo)
FROM (SELECT DISTINCT campo FROM #temp3) AS T ORDER BY campo
FOR XML PATH('')), 1, 1, '');

SET @sql = N'
SELECT * into [tempdb].[dbo].[temptable] FROM
(select cid_vend,campo,avance from #temp3) as r
PIVOT
(
sum(avance)
FOR campo IN (' + @columns + N')
) AS producto';

EXEC sys.sp_executesql @sql;
SELECT * into #temp4 FROM [tempdb].[dbo].[temptable]