with CTE AS

CTE/表变量/Temp

http://www.cnblogs.com/ziyeyimeng/articles/2366855.html