Cannot query records from a temporary table
arms777Feb 2 2011 — edited Feb 17 2011Hi. I have a procedure that populates a temporary table. Afterwhich, i need to query the records from this temp table. I tried running a report after execution of procedure but it does not show any output. I have checked the procedure and it is working fine cause i can query the records when i tried passing the output to a "regular" table. But i need to pass it to a temp table and need to query from there. How can i do this? Please help. Thanks.