Create a temporary table from a subquery in sql server causing error

sql, sql-server-2012, subquery, temp-tables

Solution

You need to alias your derived table (subquery), like:

select * into #TEmpTable
 from (
         select top 10 * from customers
      ) as [SomeAlias]

You can also:

select top 10 * 
into #temp
from customers

Problem

I have something like this ``` if object_id('tempdb.#TempHourlyTable') is not null drop table #TempHourlyTable select * into #TempHourlyTable from ( select top 10 * from customers ) ``` I get an error like this: Incorrect syntax near ')'. My first attempt with temporary tables. So what is the mistake here? EDIT: Drop and recreate if temporary table exists. Getting error Msg 2714, Level 16, State 6, Line 55 There is already an object named '#TempHourlyTable' in the database.

Original source