-- Insert
INSERT INTO table2 (column1, column2, column3, ...)
SELECT Pcolumn1, Pcolumn2, Pcolumn3, ...
FROM table_preload
WHERE OP = i;

-- Update
UPDATE TABLE final_table
SET Column = pColumns
FROM table_preload pre
WHERE pre.op = u

-- Delete
DELETE FROM final_table
WHERE idVendor NOT EXISTS (SELECT idVendor FROM preload_table WHERE op = d)