Wednesday, April 11, 2007

meter reading date correction

Corrected dates for Power Bills days 6,7,8.

Problem is, Mike uploaded the uncorrected data before I corrected the upload data files!

So I had to:

update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611011265';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010955';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010556';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010747';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010557';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010540';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010872';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511011295';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611011495';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010325';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010470';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010456';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511011446';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0101020517';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0211010582';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611011210';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611011211';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010560';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010643';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411014285';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010386';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010011';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111010666';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010000';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111011451';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010522';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111010139';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111010140';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111014270';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111014271';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010072';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511013914';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0100076916';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111010122';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611011366';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010064';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010576';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411011616';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010123';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010280';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010101';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010647';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010605';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111010251';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611014253';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010032';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111014159';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0811010734';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010049';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010050';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010053';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010054';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0500076565';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010570';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0611010222';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0411010505';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0511010574';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111014116';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0811010732';
update meter_reading set presentreading_date='2007-04-07' where actual_billing_month='200704' and oldaccount_no='0111011532';

No comments: