Re: Temporary tables

In <6b4kqa$290@news.singlepointsolutions.co.uk> "Paul N. Daly" <pndaly@globalnet.co.uk> writes: >Is it better to select into a temp table or create a temp table, prepare the >select and then use an insert cursor to populate it? And the answer is........depends! I asked the same question some time back and noone had any performance or coding etiquette worries with either method. I find that SELECT INTO TEMP is somewhat restricting as the statement cannot be run again to add additional rows to an existing table, and such like. I prefer CREATE TEMP TABLE, but it's annoying to not be able to use the LIKE clause. At least with the SELECT INTO TEMP method, changes to the database schema are picked up by the program with a simple recompile, but CREATE TEMP TABLE requires a less lazy maintenance methodology :) -- Bryan Tonnet batonnet@phase4.com.au