Community Member Profile

Recent Blog Comments By Robert Butler

• SQL COUNT( NULLIF( .. ) ) Is Totally Awesome

  Posted on Apr 24, 2010 at 6:55 AM

  sorry, I was sure this thread was referring to SQL Server.... read more »

• SQL COUNT( NULLIF( .. ) ) Is Totally Awesome

  Posted on Apr 24, 2010 at 6:33 AM

  No, Leon. That will not work. Expressions like that do not evaluate to boolean or bit values.... read more »

• SQL COUNT( NULLIF( .. ) ) Is Totally Awesome

  Posted on Mar 18, 2010 at 9:56 AM

  This works too. I learned this trick a long time ago and it's really powerful for flags. SELECT g.hair , COUNT(*) AS girl_count , sum(did_date) AS did_date_count , sum(abs(did_date - 1)) AS did_not_date_count FROM @girl g GROUP BY g.hair... read more »