You need to be careful here. Referencing a temporary table that was created outside of the stored procedure can cause the stored procedure to be recompiled.
http://www.sql-server-performance.com/rd_optimizing_sp_recompiles.asp-Mike
>Margret,
>
>I usually use a TEMP table for this. You can create the temp table in your SP, and any SP's you call from that one will be able to access the table.
>
>For more info on temp tables see the SQL BOL.
>
>BOb