Re: Need SQL Server Temp Table equivalent (challenge!)

Ok guys. I think you all are still missing my points. Here are the problems with you way of "dynamic" approach:

1. You created a PERMANENT table even though you created using dynamic sql.
2. You can't SCALE because you can't have more than 1 person using it...unless you name the table differently every time.
3. Regardless, you have to delete it because it is permanent.

I am trying to scale and that's why having a dynamic table that is visible to only one session, and each session's table may have different table structure are critical. Of course, the system should take care of the cleaning up. Being able to do this in a SP

select * from myTempAndTruelyDynamicTable

and return the result set is cool as well. But that's another topic.

Guys, I apologize if I offended any of you. But I still can't see how you can do that easily in Oracle.

Oracle's Temp Table solution is close but it still requires fixed columns. Just imagine if the Oracle's Temp table structure can be changed for each session and won't effect other sessions, then my problem is solved. Received on Tue Jul 22 2003 - 11:44:37 CDT