Need help with SQL statement

BACKUP FIRST. If at all possible, perform these operations when the store is closed.

In Store Operations:

UPDATE Item SET PriceC = Price

then...

UPDATE Item SET Price = PriceA

If you are in an HQ environment, you'll need a different set of queries.

Tom

Tom,

Thanks, i going to try it tommorow!

Tom,

Why would it be different for HQ?

Because each store can have separate prices, so ItemDynamic would have to be updated somehow. Actually, you would probably want to generate a worksheet to apply the new prices to each store, then let HQ Client & HQ Server take care of propagating the changes. The simple update to the item table would be meaningless in an HQ environment.

Glenn Adams Tiber Creek C> Tom,

Yes, but if you did the SQL you recomended to all of the the Store Ops databases, this would do the trick. Why does it matter to update the price in the HQ database at all?

"Glenn Adams [MVP - Retail Mgmt]" wrote in message news:OMcChF% snipped-for-privacy@TK2MSFTNGP03.phx.gbl...