for Agnes: (Anna Romina Yalung's receipts)
update payment p set ornumber=CONCAT('0',ORNUMBER+30000,'T') where ornumber between '0738433T' and '0738609T' and payment_date='2007-04-03';
update artran p set docno=CONCAT('0',docno+30000,'T') where docno between '0738433T' and '0738609T' and docdate='2007-04-03';
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment