Hy
If you know which values are supposed to be negative, wouldn't it be
easier to do updates to your data to change all of those values to
negatives? That should only need to be done once. Then use the normal
SQL sum() function to add all of the values together.
Thank you. Actually my first thing was update but my SQL knowledge is
weak and I don't want to mess the database.
I started a script which is update bad records on a copy of that
database. However I didn't solve the update problem.
My script is in (PL/SQL):
integer a;
integer b;
varchar tr;
varchar ra;
varchar ke;
varchar moti;
begin
select tm.tr,tm.ra,tm.ke,tm.moti,tm.mome
into tr,ke,moti,a
from ev98nv_tm tm
where MOTI like 'Rakt.kozi-' or MOTI like 'Kiadas -'
and tm.EV like '2005'
if (a >0) then
a=b;
b = 0- b;
update ev98nv_tm set mome=b where tm.tr=tr and tm.ra=ra and tm.ke=ke and
tm.moti=moti ;
end;
But it is not working. The Primary index is tr+ra+ke+moti
Rhino
___________________________________________________________
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
