Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: David Lund and Ryan Jeffords and Ryan Johnson


Member since Nov 29, 2011

Recent Blog Comments By Sam

  • Getting One Record Per Group From A One-to-Many Join

    Posted on Nov 29, 2011 at 1:17 AM

    How about: select, <!--- Phone data. ---> ( ) AS phone_number, ( p.ext ) AS phone_ext, ( ISNULL( p.is_preferred, 0 ) ) AS is_preferred FROM @contact c LEFT OUTER JOIN @phone p = group by order by is_preferred, read more »