What is the purpose of a Global Temporary Table and how does it differ from a Local Temporary Table?
Global temporary tables have two number signs (##) as the first characters of their names; they are visible to any user after they are created, and they are deleted when all users referencing the table disconnect from the instance of SQL Server.