not sure what ur saying about the selecting for a cte because u can sdo that w/ the #tables as well.

However that is very interesting the the QO will look at a @table w/ n records and take it as having 1 record. That explains some search optimization i was doing years ago that wouldn't play nice.