This highlights the issues of confusing views with tables and views referencing other views. In my 30+ years, I've found that such practices lead to more problems than solutions.

Steve Jones - SSC Editor (7/29/2016)

---

Ha, we have a living quarters as well. Maybe we can roll together to an event? Or you can swing by the ranch when you...

First off Steve, I completely agree with you about the new ruling for the 600 mile radius. Having SQL Saturdays in close proximity back-to-back allows many to attend who...

It never ceases to amaze me just how easy movies and TV make complex computing tasks like hacking unknown systems (what if the aliens didn't have a binary system?), high-speed...

pietlinden (6/30/2016)

---

I guess if you're forced to do something "clever" then you have to document your code inside the code... not in some "book" somewhere that nobody can find. (Yeah,...

Yeah,...

Personally, I prefer using an account name as email addresses are much more subject to change. I've had issues where I could not change my email account (not on...

xsevensinzx (6/24/2016)

---

I think by far the biggest hurdle for me in designing a new data warehouse or even a new database is clearly outlining the ERD and all the ETL...

I've lost track of the number of database applications that I've built from scratch over the last 30 years. One thing is true though, I never got them completely...

Way back when I was in school (still in the days of green bar line printers) subjects like database theory, set theory, and...

Yes, you are correct that column references are repeated. I feel that those...

The use of APPLY is interesting and I did learn a couple of things, but in my opinion the CTE approach exemplified earlier is cleaner and easier to read especially...

It's not teaching the crutch, but teaching that the crutch is NOT NECESSARY.

Yes, it's a lazy approach that some...

That's what I do...