INSERT CAR_DRIVE(CAR_DR_ID, CAR_ID, ASSET_ID, ASSET_NAME, OLD_INDEX_NUMBER, NEW_INDEX_NUMBER, INDEX_NUMBER, POWER_RATE, POWER_RATE_INDEX, CURR_POWER_RATE, INPUT_DT, ISLEAF, PARENT_ID, NOTES, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, CAR_AMT, INVOICE_NO, DR_ROUTE, REQ_PAY_ID, DIFF_FUEL_CONSUM, REQ_CAR_ID, OLD_FUEL_NUMBER, NEW_FUEL_NUMBER) VALUES (N'CARD00000000007', (SELECT cm.CAR_ID FROM CAR_MASTER cm WHERE cm.N_PLATE='51F-90430'), NULL, NULL, 93795, 93795, 0, NULL, NULL, 0.00, '2023-03-16 00:00:00.000', 'Y', NULL, NULL, '1', 'admin', '2023-03-16 00:00:00.000', 'Y', NULL, NULL, NULL, NULL, N'Import data', NULL, NULL, '', 0.00, 0.94)
INSERT CAR_DRIVE(CAR_DR_ID, CAR_ID, ASSET_ID, ASSET_NAME, OLD_INDEX_NUMBER, NEW_INDEX_NUMBER, INDEX_NUMBER, POWER_RATE, POWER_RATE_INDEX, CURR_POWER_RATE, INPUT_DT, ISLEAF, PARENT_ID, NOTES, RECORD_STATUS, MAKER_ID, CREATE_DT, AUTH_STATUS, CHECKER_ID, APPROVE_DT, CAR_AMT, INVOICE_NO, DR_ROUTE, REQ_PAY_ID, DIFF_FUEL_CONSUM, REQ_CAR_ID, OLD_FUEL_NUMBER, NEW_FUEL_NUMBER) VALUES (N'CARD00000000008', (SELECT cm.CAR_ID FROM CAR_MASTER cm WHERE cm.N_PLATE='51G-22596'), NULL, NULL, 26268, 26268, 0, NULL, NULL, 0.00, '2023-03-16 00:00:00.000', 'Y', NULL, NULL, '1', 'admin', '2023-03-16 00:00:00.000', 'Y', NULL, NULL, NULL, NULL, N'Import data', NULL, NULL, '', 0.00, 26.39)