automatic logging the price change after importing a new price list from the supplier
I got a problem on writing a script to complete the following task, plesase help.
I do have a table which contains all the details of individual product, including Model number, Details, Qty in Stock and Price. Every 6 to nine months, the supplier will give us a new price list (approx 500+ items) and I need to log individual item if there is a price change. My original idea is create a temp table which is exact clone of the original Product Table. When there is a new price list came in, I will Import into this Temp table. Each record will then compare to the Original Product table, if there is a price change , or new product, it will update the Orginal Product table and create a record in another table call "product update". Is my logic correct? .
THanks in Advance.. ^^