-- Temp Table Local 

Create Table #TMP_TABLE -- Create TEMP Table
(ID int,
NAME VARCHAR(20))

select 1 as ID, 'John' as NAME 
Into #TMP_TABLE -- Create And Insert Into Temp Table

select * from #TMP_TABLE

-- Temp Table Global
Create Table ##TMP_GLOBAL_TABLE -- Create TEMP Table
(ID int,
NAME VARCHAR(20))

Insert Into ##TMP_GLOBAL_TABLE values(1, 'One')

select * from ##TMP_GLOBAL_TABLE