msql how to copy the result from select statement into a temp table Edit

Here is the SQL script to copy the result from the select statement into a temp table. Please note that the temporary table is automatically created for you. This is also a solution on how to create a temp table dynamically from a select statement.

I already have a table SetupCountry, In the above code, a temp table is created with all the data from SetupCountry is coped into temporary table #SetupCountryTemp