Derived tables are cool as far as being able to write elegant code and reduce the quantity of code. I started using them for these reasons.

I have been removing them since I realized that they are performance dogs for decent-sized tables. Table variables or temporary tables are much better from a performance aspect.