0a1b5fbd   
   From: tfs@dslextreme.com   
      
   "--CELKO--"  wrote in message   
   news:0a64e8f2-18cb-4020-8ac8-4408c76ce891@i5g2000yqe.googlegroups.com...   
   >>>  I thought the CTE actually creates temp table internally. <<   
   >   
   > Not in SQL Server. It is an in-line macro and the recursive CTEs are   
   > cursors and procedural code in disguise. DB2 and Oracle optimizers can   
   > make a decision to materialize or not materialize a CTE.   
      
   That may be the case, but in a recursion case I find that the CTE works   
   better (faster) than cursors or recursive rountines.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)