Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Joshua Cyr
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Joshua Cyr@jcyr )

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 »