I'm trying to write a temporary table that I may use to sort data records that are collected in the procedure... Is there an efficient way to create the table in memory to manipulate the collected data (Sort,totals,etc...) and then delete the table after the data is written to a flat file...

I may eventually use the data in a crsytal report.

Thanks,

Marc