Hi makenzi.exc,

Use SELECT INTO statement.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

Refer below query.

SQL

SELECT [EmployeeID], 
	   CONCAT([FirstName], ' ', [LastName]) 'Name', 
	   [Country]
INTO #Employees
FROM [Employees]

SELECT [EmployeeID], 
	   [Name], 
	   [Country]
FROM #Employees

DROP TABLE #Employees

Screenshot