Temp Table 1

[nevets72]

Hi....just wondering if anyone knows the syntax for creating a temporary table in SQL 6.5.....I tried the following:

INSERT INTO #Temp_Table (Employee_Last_Name, Employee_First_Name, Actuals_Percent_Allocated,
Project_Description, Actuals_Date, Manager_Last_Name, Manager_First_Name,
Job_Code_Description) SELECT * FROM Rpt_ActPrjEm

I thought I needed to use a pound sign, but I get an 'Invalid object name #Temp_Table'. I also tried the above without the pound sign and that didn't work.....do I need to declare the temporary table name somehow before running the query? Anyone have any idea how I can do this? Thanks!

 

[jhall156]

Did you create the table first?
JHall

 

[RobertT687]

Syntax is :
SELECT * INTO #Temp_Table FROM Rpt_ActPrjEm

 

[nevets72]

excellent.......thanks, the:

SELECT * INTO #Temp_Table FROM Rpt_ActPrjEm

worked!