If this is the data you have to work with then it is a nice elegant solution 

But when dealing with hierarchical data I prefer the Nested Set Model

Great article.

Can someone explain the following to me please

So now we know the window aggregate function is the culprit. Since we’re not partitioning the data yet (but will in a...

You offer a very creative solution that has the ability to have dynamic columns. However, practically since you almost always need to know the columns names any way to...

Hugo Kornelis (6/29/2014)

---

Got it wrong.

I hate these questions where a declaration bad practice is buried under a heap of distracting code. I know that this happens in real code too,...

Yeah I don't know, that wasn't my call.

Thanks nice and easy, I knew this one from experience.:blush:

I really didn't care for this question, you must fix all errors regardless of the order they appear.

I selected the wrong answer with the User error, which was half right.

zerko (6/18/2013)

---

When I need to write this sort of query, I use "NOT IN" , instead of "<> ALL" - Seems to do the same thing, and easier to understand...

I have made the mistake of missing a comma one to many times. 😀

Thanks for the question. I only remember this from a different compiler question.

Yeah, it was just something I came across recently. A negative made it into a replication of spaces making the entire field null. Took a little bit of...

Thank you for the question.

However in SQL Server 2012, this does not appear to be the case

So the answer is No.

Thank you, I learned something this morning.