IF OBJECT_ID('tempdb..##TEMP') IS NOT NULL DROP TABLE tempdb..##TEMP;

SET NOCOUNT ON 

DECLARE @Dyn_SQL VARCHAR(1000)
SET @Dyn_SQL = ''

IF OBJECT_ID('tempdb..#Temp') IS NOT NULL
DROP TABLE #Temp

; with cte (N) as 
(
	select 1 n union all 
	select 1 n union all 
	select 1 n union all 
	select 1 n union all 
	select 1 n 
)
SELECT N into #Temp FROM cte

SELECT @Dyn_SQL = 'SELECT N FROM #Temp ; UPDATE #Temp SET N = N + 1 ; SELECT N FROM #Temp ; DROP TABLE #Temp  '

EXEC (@Dyn_SQL)

SELECT N FROM #Temp