It's kind of funny. I posted similar question about CTE performance almost a year ago:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=149&messageid=289849

but I guess it was too early for anybody to respond.