Community Member Profile
Corey G
Member since Dec 11, 2009
- Profile: /members/4941-Corey-G.htm
- Comments: 1
- Points: 9
Recent Blog Comments By Corey G
-
SQL COUNT( NULLIF( .. ) ) Is Totally Awesome
Posted on Dec 11, 2009 at 10:35 AM
Thanks, was looking for this with aggregates. Another nice use is for the div by zero issue: /isnull(nullif( denominator ,0),1) which returns 1 instead of 0 to divide by in case you want to avoid a filter within the WHERE section.... read more »
