A SQL Server 7 Question

[freewilly]

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.

[zopailot]

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!!

[freewilly]

Thanks

Do it have to use a table? Can I create an internal recordset instead and query that? It would be quicker!