Sergiy (1/6/2016)

---

Lynn Pettis (1/6/2016)

---

Same could be said if you populate temporary tables with the results of a complex query and then use that table in another query. You have...

erics44 (1/6/2016)

---

Sergiy (1/6/2016)

---

Very questionable. Very.

CTE's break the structure of Structured Query Language, moving part of FROM effectively...

Making it easier for others:

http://kb.winzip.com/kb/entry/125/

Phil Parkin (1/6/2016)

---

Alvin Ramard (1/6/2016)

---

Jeff Moden (1/6/2016)

---

Brandie Tarvin (1/6/2016)

---

djj (1/5/2016)

---

There all over...

Reminds me of an issue with an application I helped support at a previous employer. For years there was an intermittent problem where when a sales person converted a...

Spoiler alert, I think this works as the itvf. No tables or data to test against. Only issue I have is not being able to identify which table...

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 clause as...

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, and as...

Sergiy (1/5/2016)

---

The fact is - CTE is a foreign construction in SQL.

It was copied to T-SQL from front end languages to create more comfortable environment for those ".Net developers with...

SQLDCH (1/5/2016)

---

I'd really prefer to stick with our current scoring. I'm not a fan of FLEX positions or PPR leagues. But, if the majority out votes me, I'll...

Count me in for another year.

Wayne West (1/4/2016)

---

There's some gaps that have developed in my knowledge of T-SQL that I need to fill in. I'd like to work on that and also on re-learning...

Good question. Just one minor thing, I'd use the following the end of the calendar year:

SELECT DATEADD(DAY, -1, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()) + 1, 0));

The interesting part, all three updates resolve to the same execution plan. Three different ways to tell SQL Server the WHAT you want but it all comes down to...

Alan.B (1/4/2016)

---

erics44 (1/4/2016)

---

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...