I run into this all the time but can’t ever remember the syntax. First, check to see if it exists and if it does, drop it. IF OBJECT_ID(‘tempdb..#MyTempTable’) IS NOT NULL Drop Table #MyTempTable Second, build your table. The “#”…
I run into this all the time but can’t ever remember the syntax. First, check to see if it exists and if it does, drop it. IF OBJECT_ID(‘tempdb..#MyTempTable’) IS NOT NULL Drop Table #MyTempTable Second, build your table. The “#”…