Accessing temporary table from stored procedure

[sonysunny]

Hai,

I have a temporary table created in a stored procedure.How can i access that temporary table from another stored procedure.

thanks in advance.

[amitpatel66]

Hai,

I have a temporary table created in a stored procedure.How can i access that temporary table from another stored procedure.

thanks in advance.

If the temporary table created by stored procedure one is not dropped with in the procedure, then you can access that table using a simple select statement in second procedure. But make sure you execute procedure 1 so that the table gets created and then execute procedure 2 to access that table.

But once the table is created and you run procedure1 again, it will error out saying the table already exists. So make sure about your work around and requirement.

[ck9663]

Here's more about temporary table. Just search the word Temporary Table and there are explanations of various kinds.

-- CK

[Brad Orders]

Hi SonySunny

It sounds like you have a scope issue. If you always call the second stored procedure after the first stored procedure, then you should call the second stored procedure from within the first stored procedure using the "EXEC" command. Then the second stored procedure will be able to "see" the temporary table.

However, if the first and second stored procedures do not always follow each other, I would suggest that you don't use a temporary table. Use a "real" database table. Then you won't have problems accessing it from another stored procedure.

HTH

Brad