another question

From: ashleyT (anonymous_at_discussions.microsoft.com)
Date: 04/13/04 

Date: Tue, 13 Apr 2004 07:01:03 -0700

Thanks for the note Vishal,

What if each had a date. So that

create table #cartype(manufacturer varchar(500), itemnumber int, datemade date)
  insert into #cartype values('Toyota',1, 4/6/2004)
  insert into #cartype values('Toyota',1, 4/6/2004)
   insert into #cartype values('Honda',2, 4/6/2004)
  insert into #cartype values('Honda',2, 4/6/2004)
  insert into #cartype values('Toyota',1, 4/7/2004)
  insert into #cartype values('Honda',3, 4/7/2004)
  insert into #cartype values('GE',3, 4/7/2004)
  insert into #cartype values('GE',3, 4/7/2004)

So that
insert into #cartype values('Toyota',1, 4/6/2004)
insert into #cartype values('Honda',2, 4/6/2004)
Would get deleted because there the exact same records (same number) of records are duplicated for that date.

But the records:
   insert into #cartype values('Toyota',1, 4/7/2004)
  insert into #cartype values('Honda',3, 4/7/2004)
  insert into #cartype values('GE',3, 4/7/2004)
  insert into #cartype values('GE',3, 4/7/2004)

The GE records would stay because all of the records are not duplicated, just the GE records are so I want to keep all the records.

Thanks for any ideas!