Re: another question

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 04/13/04 

Date: Tue, 13 Apr 2004 19:52:05 +0530

  Try query as follows:

    delete a
    from #cartype a join
    (select manufacturer, datemade, count(*) cnt
     from #cartype
     group by manufacturer, datemade
     having count(*) > 1) b on a.manufacturer = b.manufacturer and
     a.datemade = b.datemade and b.cnt <>
     (select count(*)
      from #cartype x
      group by manufacturer
      having x.manufacturer = b.manufacturer)

  --
  Vishal Parkar
  vgparkar@yahoo.co.in