Re: Update problems ...
From: Darryl Snedeker x52168 <dsnedeke>
Date: 1995/07/27
Message-ID: <DCDy74.ro_at_txnews.amd.com>#1/1
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, TexasReceived on Thu Jul 27 1995 - 00:00:00 CEST