IF OBJECT_ID('tempdb..#Emp05') IS NOT NULL DROP TABLE #Emp05; IF OBJECT_ID('tempdb..#Dept05') IS NOT NULL DROP TABLE #Dept05; CREATE TABLE #Dept05 (Id INT PRIMARY KEY, Location VARCHAR(50)); CREATE ...