Temporary tables with the same name could not be (re) created in a procedure – a case study A complex SQL server procedure is under development. The Developer wants to reduce the complexity, he noted that if intermediate results are populated to a staging table, the logic would be much simpler. No worries!! He created an intermediate table on the fly. Everything work perfect. The modified code looks like the following: