Hi guys, please help me with following:
I have table "Products" and have following task: Count evarege cost and update cost of all products in column "UnitPrice" with conditions if current price > everage then -10% if < +20%
By the way need to use variables
Please help me to write script I use SQL server 2000
Thanks everybody before.
I have table "Products" and have following task: Count evarege cost and update cost of all products in column "UnitPrice" with conditions if current price > everage then -10% if < +20%
By the way need to use variables
Please help me to write script I use SQL server 2000
Thanks everybody before.
Comment