Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Kevin Schmidt and Liz Frederick
Ben Nadel at CFUNITED 2010 (Landsdown, VA) with: Kevin Schmidt ( @schmidtkevinall ) and Liz Frederick@lizign )

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 »