Temp table value problem

I created temp table like the below, select into the values, however, I got the error says"There is already an object named '##report' in the database.".  Please help

Create table ##report
(
OMSC# int,
Total_Received int,
Total_Action int,
Monthly varchar(10),
Percentage decimal
)
select *
into ##report
from Requests

March 23rd, 2015 3:06am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics