Looking for SQL Debugger

Are you using SQL Server?

You can debug Stored Procs in Query Analyzer - I never find the debugger that useful myself - I don't think it will show you your temporary tables.

You might want to run a "select * from #temptablename" at various points in your SQL code to help your debugging and print statements to monitor your variables.