At 03/18/2002 08:15 PM (Monday), DaveR wrote:

>The most recent one for each contact type for a given contactid

What about:

select contactid, contacttypeid, max(contactdate) from contacthistory
group by contactid, contacttypeid