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

Murugan Andezuthu Dharmaratnam | 15 October 2020 | 106

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.

Subtitle with Paragraph

select * into #SetupCountryTemp from SetupCountry
                    

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