my temp table name is #TestTable
create TABLE #TestTable (FunctionalityID int, PageCode nvarchar(250), NameE nvarchar(250), ControlType nvarchar(250), ControlName nvarchar(250))
INSERT INTO #TestTable(FunctionalityID , PageCode , NameE , ControlType , ControlName )
(SELECT execute...