invalid object when use of temporary table
hello
i want to use a stored procedure
I use the creation assistant (after the parameters) i have an error "Object Name #NAMEOFTEMPTABLE not valid"
Is there any way to remove this error ?
Note :
The stored procedure consist of :
CREATE TABLE #NAME (...)
INSERT INTO #NAME (...)
SELECT #NAME
In the SQL Server management studio, it works and send me only one table
Regards
i want to use a stored procedure
I use the creation assistant (after the parameters) i have an error "Object Name #NAMEOFTEMPTABLE not valid"
Is there any way to remove this error ?
Note :
The stored procedure consist of :
CREATE TABLE #NAME (...)
INSERT INTO #NAME (...)
SELECT #NAME
In the SQL Server management studio, it works and send me only one table
Regards
Comments
I have same problem. given link is not working for workaround. please suggest me?