Timeline for Global Temporary Table used in Stored Procedure executed concurrently across sessions
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 19, 2015 at 13:54 | vote | accept | Travis Peterson | ||
| Jun 19, 2015 at 13:54 | comment | added | Travis Peterson | Wow, you're absolutely right it does work. I don't know what I was doing wrong before but using a #tmptbl is working now. Previously I was getting a message stating #tmptbl didn't exist.. | |
| Jun 18, 2015 at 5:04 | comment | added | Solomon Rutzky | @TravisPeterson Either you are not giving the full context of what you are trying to accomplish, or you had some syntax error. I have updated the code in my answer to match your updated code from the question. As you can see, a local temp table works just fine :-). | |
| Jun 18, 2015 at 5:03 | history | edited | Solomon Rutzky | CC BY-SA 3.0 |
added 1121 characters in body
|
| Jun 17, 2015 at 16:46 | comment | added | Travis Peterson | The table exists inside that same stored procedure. I'll add more to my 2nd snippet for clarification. I was receiving the error that the #BOM table did not exist when I tried it with a regular temp table. | |
| Jun 17, 2015 at 5:59 | history | answered | Solomon Rutzky | CC BY-SA 3.0 |