Script As Insert
Published 29 October 2019
In the results grid in SSMS, highlight the required columns then right-click and choose Script As INSERT. This will open a new query window in SSMS, containing a script that inserts the results into a temporary table. You can either create a temporary table of data, or simply grab the VALUES clause, and use it to load a copy of the table from which you originally selected the data.