Hi Jarrell

I migrated from Informix to MS SQL a few years ago and at the beginning I had similar dilemma.

I simply started using"

SELECT col1,col2

INTO #tmp_tbl

FROM some_table;

instead of informix

SELECT col1,col2

FROM some_table

INTO TEMP tmp_tbl WITH NO LOG;

Br,

Mike