Home Forums SQL Server 2005 T-SQL (SS2K5) Temp Table Name confusion with Nested Procedures? RE: Temp Table Name confusion with Nested Procedures?

  • Can you possibly explain what that means?

    On the one hand, BOL says

    "All references to the table name in the nested stored procedure are resolved to the table created in the nested procedure"

    So the temp table in the nested proc is always the one created in that proc.

    Under what circustances does SQL server get confused?

    Thanks