Being Too Clever For Your Own Good
Wednesday, August 24th, 2005 by Mark Rittman
I was with a client the other week and was asked to look at a particular SQL statement that kept failing due to lack of TEMP space. It looked something like this (names changed to protect the innocent, etc.) CREATE TABLE lookup_table AS SELECT destn, studref, min(pi) pi fROM ( SELECT pct1.DES as container_type ,pc1.ID [...]

