IF object_id('tempdb..#Temp01') IS NOT NULL DROP TABLE #Temp01' ... SELECT * INTO #Temp01' FROM mytable EXEC My OtherSP ... IF object_id('tempdb..#Temp01') IS NOT NULL DROP TABLE #Temp01'>Please forgive my lack here. I have not used this method and I guess I am getting poor at looking up