>My understanding is Common Table Expressions (CTE) offer sensational performance gains. A guy I worked with on my most recent project practically spoke in tongues about them. He said he had one monstrous query in a daily batch job that went from something like 40 minutes to 30 seconds when changed to use a CTE. I did not confirm that, that's just what he said.
