101 reputation
bio website nimblecoder.com/blog
location Houston, TX
age 41
visits member for 3 years, 1 month
seen Dec 19 '14 at 1:22
C, C++, C#, VB, VB.NET, Delphi, Python, and lots of SQL. I have designed and built drivers, communications software, embedded systems, enterprise applications, web applications, and more.

comment What's the difference between a CTE and a Temp Table?
If you need a CTE and want to reuse the CTE results (usually recursion in my scenarios), you could always insert the results into a temp table or table variable. So it is easy to use one or the other or both.
awarded  Autobiographer