Viewing 15 posts - 1 through 15 (of 118 total)
This method seems like it has a lot of drawbacks. Even the article...
August 31, 2018 at 9:10 am
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
August 31, 2018 at 7:26 am
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...
June 9, 2016 at 6:22 am
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...
March 22, 2016 at 6:01 am
Hugo Kornelis (6/29/2014)
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,...
June 30, 2014 at 7:30 am
Why this question is worth 4 points ?:hehe:
Yeah I don't know, that wasn't my call.
June 30, 2014 at 7:27 am
Thanks nice and easy, I knew this one from experience.:blush:
July 9, 2013 at 6:32 am
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.
June 24, 2013 at 6:12 am
June 18, 2013 at 7:32 am
I have made the mistake of missing a comma one to many times. 😀
June 18, 2013 at 7:27 am
Thanks for the question. I only remember this from a different compiler question.
May 24, 2013 at 6:19 am
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...
May 23, 2013 at 6:06 am
Thank you for the question.
May 17, 2013 at 6:39 am
However in SQL Server 2012, this does not appear to be the case
So the answer is No.
May 14, 2013 at 2:29 pm
Thank you, I learned something this morning.
April 30, 2013 at 6:34 am