>Hi Borislav
>
>>How you create Temp table?
>
>My favourite way is as follows:
>
=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")
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
