Recent content by tomharrow

ok that returned 206066 rows

nocoolhandle - excellent advice i have taken that onboard :) there are no null values in theemail field

Thanks that time it worked ... but only removed about 1800 records??

NoCoolHandle please excuse my ameteurness but i am having trouble understanding your pseudo code. would the following be correct? autoid is my PK field select * from customer go delete from customer where c1 not in (select min(c1) from customer d2 where d2.email = customer.email group by...

Hi Guys thanks so much for your help. but the following script (affected 0 records) am i doing something wrong? before running this i did the following just to make sure select count(email) from customer = 809639 select count(distinct(email)) from customer = 444327 DELETE FROM customer...

Hi All I have a table of approx 500,000 members which I need to dedupe only by email address. and i dont mind which records get removed. as long as there is a unique email address. e.g. tom, harrow, tom@tom.com, 30/09/1978, blue, £456 thomas, harrow, tom@tom.com, <NULL>, blue, £456 tom...

Hi Willy Have you made any progress on your issue? I seem to be having the same problem. IIS stopped serving .asp pages for no apparent reason yet serves .html files. Event viewer publishes the following error: The COM+ System Application service terminated unexpectedly. I can't for the life...