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