Insert in temporary table

[hans.schermer@PICA.NL]

Hello,

I have been trying to do the following:

I want to sort a report by a string value. I first select all the records I want
in the report. For every record I 'compute' an associated string in a user 
defined procedure.
I then want to store the record with the associated string in order to sort by 
the string. Alas, because the insert is nested in the main select loop, SQR has 
opened another session to the SQL server in which the temporary table is not 
known.
I can not use a permanent table, because the logging could fill up the 
transaction log in some situations.

Any suggestions?


Hans Schermer,
Pica Library Automation,
Leiden, The Netherlands
+31-71-257168
hans.schermer@pica.nl