hmmmmmm, seems like a very profound thing to say

and at...

below86 (1/6/2016)

---

Lynn Pettis (1/6/2016)

---

jaime.simancas 27970 (1/6/2016)

---

erics44 (1/6/2016)

---

below86 (1/6/2016)

---

I've had to work with a group of contractors for over a year now, and I find their use of CTE's to be...

Lynn Pettis (1/6/2016)

---

One thing that would be nice is if Microsoft implemented CTEs more like the way Oracle implemented their sub-query refactoring clause. Oracle can treat the sub-query refactoring...

jaime.simancas 27970 (1/6/2016)

---

erics44 (1/6/2016)

---

jaime.simancas 27970 (1/6/2016)

---

Now, I think the question you are asking is what preference is on CTE use?

If so, a common answer is, for simplicity. To create a...

Lynn Pettis (1/6/2016)

---

jaime.simancas 27970 (1/6/2016)

---

erics44 (1/6/2016)

---

below86 (1/6/2016)

---

I've had to work with a group of contractors for over a year now, and I find their use of CTE's to be excessive,...

below86 (1/6/2016)

---

I've had to work with a group of contractors for over a year now, and I find their use of CTE's to be excessive, and as you mentioned most...

jaime.simancas 27970 (1/6/2016)

---

Now, I think the question you are asking is what preference is on CTE use?

If so, a common answer is, for simplicity. To create a more readable script...

A CTE allows you to define a complex subquery once and refer to it multiple times in the same query without repeating the code. Technically possible before CTE, but cumbersome....

ill be honest tho

since I started this thread I have started using CTEs a more and not just for recursive requirements or when I need the code more than once...

Jason A. Long (1/4/2016)

---

It's just a matter of personal preference...

For simple queries, with a single, simple derived table, I tend not to care one way or another. They're both...

Yeah I agree, you don't need a cte

And I can't see why you would use a cte in that situation, just adds a level of complexity

Alan.B (1/4/2016)

---

Except for recursive CTEs, CTEs and Subqueries are basically the same thing. I prefer CTEs for a couple things:

First, for nested queries. CTEs make nested queries much more readable...

Rich Mechaber (1/4/2016)

---

One of my more common uses of CTEs is to pre-assign row-ordered values like ROW_NUMBER(), NTILE(), etc., which I can then aggregate on in a final select.

Any kind...

thanks all

CTEs seem to be a lot more popular than id expected them to be

I'm not sure I agree with the readability of CTEs, I prefer the code in the...

John Mitchell-245523 (12/24/2015)

---

I prefer CTEs to subqueries because you can get all the definitions out of the way at the front, and then the main query looks more neat and...