Alan.B (1/7/2016)

---

erics44 (1/7/2016)

---

Lynn Pettis (1/7/2016)

---

You have to remember that many times threads go off on tangents, and sometimes the tangents actually impart knowledge that may not have been provided otherwise.

I...

erics44 (1/7/2016)

---

ha, very true

thing is, unlike whether a CTE can spoil a nice bit of...

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

Jason A. Long (1/6/2016)

---

below86 (1/6/2016)

---

erics44 (1/6/2016)

---

That is so true,...

below86 (1/6/2016)

---

erics44 (1/6/2016)

---

jaime.simancas 27970 (1/6/2016)

---

erics44 (1/6/2016)

---

hmmmmmm, seems like a very...

below86 (1/6/2016)

---

jaime.simancas 27970 (1/6/2016)

---

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

erics44 (1/6/2016)

---

hmmmmmm, seems like a very profound thing to say

and...

below86 (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, and...

below86 (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, and...

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

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

Yes, you will find queries which live all over the spectrum. again, sticking to Set Theory and making code easy to read, that is key.

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

For SQL Server BI,

1. Setup Disk

2. Install New Instance

3. Select Integration Services

This will also install SQL Server Data Tools (which will contain everything you...

Iwas Bornready (2/11/2015)

---

I do my best thinking in silence. Others around me had headphones on or just listen to the music playing over the speaker system. If I have to...