Pulling from variable into temp table

See more:

SQL-Server-2016

This is a snipbit of the entire project. What I'm trying to do is select @Begin execute @Begin and then put those results of the While loop into the #While_Loop temptable but I keep coming up with nothing being put into the Temp or just the string that @begin getting put into the Temp. Essentially I just need help with the Syntax of the 'Insert into' section

Declare @TTWhile varchar(30)
If @ProgID <> 0 Select @TTwhile = '#temp_prog_course_list_GR'
If @ConcID <> 0 Select @TTWhile = '#temp_prog_course_list_UG'


declare @Begin nvarchar(max)


Select @Begin = '
declare @ctr int, @max int, @Coursecode varchar(25), @Coursecode2 varchar(50), @courseCodeList varchar(max), @CourseCodeList2 varchar(max)
set @ctr = 1


Select @max = max(RecordID) From ' + @TTWhile + '


While @ctr <= @max
Begin

Select @CourseCode = ltrim(rtrim(courseCode))
From ' + @TTwhile + ' where RecordID = @ctr

Select @courseCodeList = coalesce(@courseCodeList + '','' + @CourseCode, @CourseCode)


Select @CourseCode2 = '' max(''+ltrim(rtrim(courseCode))+'') as [''+ltrim(rtrim(courseCode))+'']''
From '+ @TTwhile + ' where RecordID = @ctr

Select @courseCodeList2 = coalesce(@courseCodeList2 + '','' + @courseCode2, @courseCode2)

Select @ctr = @ctr + 1
End'



exec (@begin)


Create Table #While_Loop
(cc1 nvarchar(max),
cc2 nvarchar(max))


Insert into #While_Loop --select (cc1, cc2)
From @begin


Declare @cc1 varchar(max), @cc2 varchar(max)
select @cc1 = (Select cc1 From #While_Loop)
select @cc2 = (Select cc2 From #While_Loop)

What I have tried:

select * into

Insert into ... exec

etc...