I want to run some updates on a hard table within a transaction, and insert rows into a temp table based on the newly updated hard table, but I don't want to lose the temp table after the transaction is rolled back...is this possible?
I feel like there is an OBVIOUS answer here, and I'm just not seeing it.