ByronOne (4/11/2013)
Hi LynnIs it possible to adapt this code slightly so that rather than updating the sales figures for a specified product type ie LEISURE. It creates a new product type ie NEW_LEISURE with the new sales figures.
Basically I want to update the sales figures but I'd like to keep a record of the old sales figures too.
Hope that makes sense..
BO
Don't know. Since I don't have access to your database, I am extremely limited in what I can do. Perhaps if you were to read the first article I reference in my signature block below and provide the DDL (CREATE TABLE statement) for the table(s) involved, sample data as a series of INSERT INTO statements for the table(s), expected results based on the sample data someone may be help with this modification.