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 cf.Objective() 2012 (Minneapolis, MN) with:

Sam

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 c.name, <!--- Phone data. ---> ( p.name ) AS phone_number, ( p.ext ) AS phone_ext, ( ISNULL( p.is_preferred, 0 ) ) AS is_preferred FROM @contact c LEFT OUTER JOIN @phone p c.id = p.id group by c.id order by is_preferred, p.name... read more »