Wednesday, December 15, 2021

Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008

Click this article to see how CTEs and UNION ALL can be used to create a recursive query to flatten a hierarchy relationship into a bread crumb style path: Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008

Saturday, December 19, 2015

Monday, December 14, 2015

Monday, December 7, 2015

Inner Vs. Outer Join

What is the difference between and inner and out join in SQL?  I hear this question a lot (at work, when I conduct interviews, and when I'm interviewed).  The answer isn't as straight forward as you may think.  Here is a diagram from the article  "Visual Representation of SQL Joins" by C.L. Moffat that show's a visual representation of what each time of join does:



There are other good discussion on the difference between inner and outer joins found in Stack Overflow.

Thursday, November 19, 2015

Python IDEs





You can use a text editor, like sublime text, if you are learning or doing very simple things.