=SQLEXEC(lnSQLHandle, "DROP TABLE #outcome", "outcome") > TEXT TO lcSQL NOSHOW TEXTMERGE > SELECT ... > INTO #outcome > FROM ... > WHERE ... > ENDTEXT > =SQLEXEC(lnSQLHandle, lcSQL, "outcome")Then use:
=SQLEXEC(lnSQLHandle, "DROP TABLE #outcome", "outcome") TEXT TO lcSQL NOSHOW TEXTMERGE SELECT ..., IDENTITY(int, 1, 1) AS Rec_No INTO #outcome FROM ... WHERE ... ENDTEXT =SQLEXEC(lnSQLHandle, lcSQL, "outcome")