Printable View
Hi Team
Sorry to ask SS7 questions but I'm sure heaps of you will know the answer.
In Stored procedures there is a way to to declare something resembling an internal tempory table. You can then fill it with the results of a query.
You can then run further queries in the same stored procedure from the internal temporary table that was previously created.
Can someone remind me how this is done.
You can create a temporary table with
this statement
Create Table #MyTemp as , .....
The # indicates that this is a temp table that will be
alive during your session and only the user who created
can see it
if you need a table to available to the rest of the users
you have to use ## instead !!
Hope It Works For you!!
Thanks
Do it have to use a table? Can I create an internal recordset instead and query that? It would be quicker!