Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Cyril Hanquez and Hugo Sombreireiro and Reto Aeberli and Steven Peeters and Guust Nieuwenhuis and Aurélien Deleusière and Damien Bruyndonckx
Ben Nadel at Scotch On The Rocks (SOTR) 2011 (Edinburgh) with: Cyril Hanquez@Fitzchev ) , Hugo Sombreireiro@hsombreireiro ) , Reto Aeberli@aeberli ) , Steven Peeters@aikisteve ) , Guust Nieuwenhuis@Lagaffe ) , Aurélien Deleusière@adeleusiere ) , and Damien Bruyndonckx ( @damienbkx )

Pedro

Member since Sep 14, 2009

Recent Blog Comments By Pedro

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

    Posted on Sep 14, 2009 at 6:51 PM

    Just amazing, I did something like this: SELECT sum(case when paytype = 1 then amount else 0 end) as bpay, sum(case when paytype = 2 then amount else 0 end) as paypal, sum(case when paytype = 3 then amount else 0 end) as ccard FROM payments WHERE fkclientid = 20503... read more »