temp tables?
I'm a tad confused here. I thought when you used the syntax...
CREATE TABLE ##m_tblOpenReceipts(
...that the table was destroyed when the stored procedure ended. So why, when I try to run it a second, time, do I get the error...
Msg 2714, Level 16, State 6, Line 43
There is already an object named '##m_tblOpenReceipts' in the database.
...?
(This is also the case with a single pound.)
If I'm wrong about this, as I seem to be, how does one create a true temp table?
CREATE TABLE ##m_tblOpenReceipts(
...that the table was destroyed when the stored procedure ended. So why, when I try to run it a second, time, do I get the error...
Msg 2714, Level 16, State 6, Line 43
There is already an object named '##m_tblOpenReceipts' in the database.
...?
(This is also the case with a single pound.)
If I'm wrong about this, as I seem to be, how does one create a true temp table?
