Problem:

The method to create a global temporary table under SQL Server.

Resolution:

With SQL Server, a global temporary table needs to be prefixed with ## . This statement will create a global temporary table ##tmptable

           EXEC SQL Create table ##tmptable (col1 char(10) , col2 varchar(30))

           END-EXEC