sql server insert into temp table

Solutions on MaxInterview for sql server insert into temp table by the best coders in the world

showing results for - "sql server insert into temp table"
Paolo
07 Sep 2016
1--This will create a temp table on the fly
2SELECT last_name, first_name, hire_date, job_title 
3INTO #tmp_employees
4FROM dbo.employee
5WHERE hire_date > '1/1/2010'