I have a temporary table #tmpTable that will be created dynamically. - The code to create the temp table will look like the attached code.
I have another permanent table that will contain the data that I want to insert into my temp table based.
For example if my temp table has ColumnA, ColumnB and ColumnC then the permanent table would have the same columns plus the data.
How would I join these two tables together to get data from one table to another.