101 reputation
1
bio website nimblecoder.com/blog
location Houston, TX
age 40
visits member for 2 years, 5 months
seen Apr 18 '12 at 22:21
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.

Feb
16
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.
Feb
16
awarded  Autobiographer