Re: Update problems ...

From: Darryl Snedeker x52168 <dsnedeke>
Date: 1995/07/27
Message-ID: <DCDy74.ro_at_txnews.amd.com>#1/1


Try this or some derivation thereof

drop table xyz;
create table xyz as
select rtrim(serial_number) serial_number, count(*) from ammo
group by rtrim(serial_number)
having count(*) > 1;

In the least, this will identify the records that are causing the problem and place them in a table. The purpose of placing them in a work table is to help you create an application to effectively resolve your issue of concern and subsequently perform testing.

Good luck
-D
--

Darryl Snedeker 		ph# (512) 602-2168
Senior Database Administrator	fax (512) 602-5018
Advanced Micro Devices		Austin, Texas
Received on Thu Jul 27 1995 - 00:00:00 CEST

Original text of this message