If I can write my stored procedure using derived tables instead of temp tables, should I do so? Or are temp tables o.k. if I want to keep my stored procs easy to read?
Also, what are the pitfalls of using temp tables over derived tables?
Tim Westmoreland
Software Engineer
Skyline Technologies, Inc.
"Upper classes are a nation's past; the middle class is its future." - Ayn Rand, Russian-born author (1905-1982).