• First, I would just refer to a temp table by its name and not fully qualify it.

    Second, it you're in a loop, you may not need to create and drop the table over and over again. It may be better to create it at the start of the procedure, clear it out at the end of each iteration, then drop it at the end of the procedure. Use "set statistics time on" to examine performance implications.

    I know these are generalities, but I would need to see the code to offer any specific suggestions.