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

  • OK, this procedure and it's nested cousin caused issues again this morning. Here is the odd part, the proc. running through Crystal Reports ran just fine. I open the procedure in SSMS, again straight from the server to be sure it is indeed the code in question) and it errors out.

    I changed the name of the temp table that I thouht it was confused about (so that the two procs were not using a temp table with the same name) and it runs fine. So it looks like the SQL Engine can indeed get confused that way. :exclamationmark:

    The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking