SQL - How to SELECT declared variables into #temp table

INSERT INTO #TempTables SELECT @var1, @var2\nSelect ... into creates a new table (which is already created in your case). Insert ... select inserts data into existing table.\n\nUpdate\nMore explanation.\nSQL Server doesn't allow creating 2 tables with the same name. In your case you have local temporary table which is created twice (1st time CREATE TABLE, 2nd SELECT ... INTO..), so you get an error.\nDepends on what you want you can\n1. Drop table and create it again\n2. Remove all data (if any) from it and populate it with INSERT INTO... SELECT",

You must have added drop table @myTempTable at a later point, so SQL Server still sees this table. Open a new query window and do a\n\ndrop table #myTempTable \n\nThen you can execute your original command:\n\nCREATE TABLE #myTempTable\n(\n [value1] varchar(10),\n [value2] varchar(20)\n)\n\ndeclare @var1 varchar(10), @var2 varchar(20)\n\nSELECT @var1 = [value1], @var2 = [value2]\nFROM somePermTable\nwhere Condition = true\n\nSELECT @var1, @var2 INTO #myTempTable\n\ndrop table #myTempTable\n\n\nLooks like you have a temp table already, simply drop it first\n\nDROP TABLE #myTempTable",