38 lines
2.4 KiB
Plaintext
38 lines
2.4 KiB
Plaintext
update mmt_staging1.mmt_staging_generic_table
|
|
set column53=0
|
|
where file_syspk = 263;
|
|
update mmt_staging1.mmt_staging_generic_table
|
|
set column53=0
|
|
where file_syspk = 262;
|
|
|
|
delete from mmt_ods.test_instance where test_file_ref_no = 263;
|
|
delete from mmt_ods.test_instance_engine_info where test_file_ref_no = 263;
|
|
delete from mmt_ods.test_instance_tractor_info where test_file_ref_no = 263;
|
|
delete from mmt_ods.test_instance_drawbar_info where test_file_ref_no = 263;
|
|
delete from mmt_ods.test_instance_tyre_info where test_file_ref_no = 263;
|
|
delete from mmt_ods.drawbar_perf_results_summary where test_file_ref_no = 263;
|
|
delete from mmt_ods.drawbar_perf_oecd_results where test_file_ref_no = 263;
|
|
delete from mmt_ods.drawbar_perf_results where test_file_ref_no = 263;
|
|
delete from mmt_ods.test_instance_equipment_info where test_file_ref_no = 263;
|
|
delete from mmt_ods.test_instance_measurement_uncertainty where test_file_ref_no = 263;
|
|
delete from mmt_ods.test_instance_tractor_info_misc where test_file_ref_no = 263;
|
|
delete from mmt_ods.test_instance_gear_speed_chart where test_file_ref_no = 263;
|
|
delete from mmt_ods.Test_instance_wheels_info where test_file_ref_no = 263;
|
|
delete from mmt_ods.Test_instance_fuel_lubricant_info where test_file_ref_no = 263;
|
|
delete from mmt_ods.drawbar_perf_observations where test_file_ref_no = 263;
|
|
|
|
|
|
delete from mmt_ods.test_instance where test_file_ref_no = 262;
|
|
delete from mmt_ods.test_instance_engine_info where test_file_ref_no = 262;
|
|
delete from mmt_ods.test_instance_tractor_info where test_file_ref_no = 262;
|
|
delete from mmt_ods.test_instance_drawbar_info where test_file_ref_no = 262;
|
|
delete from mmt_ods.test_instance_tyre_info where test_file_ref_no = 262;
|
|
delete from mmt_ods.drawbar_perf_results_summary where test_file_ref_no = 262;
|
|
delete from mmt_ods.drawbar_perf_results where test_file_ref_no = 262;
|
|
delete from mmt_ods.test_instance_equipment_info where test_file_ref_no = 262;
|
|
delete from mmt_ods.test_instance_measurement_uncertainty where test_file_ref_no = 262;
|
|
delete from mmt_ods.test_instance_tractor_info_misc where test_file_ref_no = 262;
|
|
delete from mmt_ods.test_instance_gear_speed_chart where test_file_ref_no = 262;
|
|
delete from mmt_ods.Test_instance_wheels_info where test_file_ref_no = 262;
|
|
delete from mmt_ods.Test_instance_fuel_lubricant_info where test_file_ref_no = 262;
|
|
delete from mmt_ods.drawbar_perf_observations where test_file_ref_no = 262; |