CREATE TABLE ##tempGlobal ( nameid int, fname varchar(50), lname varchar(50) ) Once created, these tables are used just like permanent tables; they should be deleted when you are finished with them.