Viewing 7 posts - 1 through 7 (of 7 total)
One of the more prominent MVPs - while he failed to react to this thread - has provided a comprehensive article relating to ISNULL and COALESCE: http://sqlmag.com/t-sql/coalesce-vs-isnull. After reading it,...
June 9, 2016 at 10:53 am
Nice article and nice work on the floating-point exception bug.
Now, to give this dead horse the final whiplash, I was intrigued by the IN handling and modified the set...
October 22, 2011 at 4:59 pm
Michael Ebaya (11/3/2010)
happycat59 (11/3/2010)
Not only is the original article of interest (and it is great to have someone prepared to write about their findings...thanks Terry)
Does no one actually care the...
November 4, 2010 at 8:59 am
Adding a numeric value turns the expression into an int because of type precedence rules. The fact that 'abcd' does not readily convert into an int does not stop this...
July 8, 2010 at 6:56 am
The documentation is slightly different; 2005 BOL says that when "replacement_value" is returned, it will be implicitly converted to the type of "check_expression" while 2000 BOL just demands both expressions...
December 11, 2009 at 4:53 am
Considering the simplicity and apparent history of working reliably in several places, I found a surprisingly large number of finer points in the submitted code. The asymmetry in trimming was...
December 2, 2009 at 2:22 am
This article http://en.wikipedia.org/wiki/Rounding explains various rounding techniques.
After reading the Wiki article, my guess is that MDX uses it because it is the only deterministic method which is essentially non-biased, also...
October 6, 2009 at 1:49 am
Viewing 7 posts - 1 through 7 (of 7 total)