• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 209
  • Last Modified:

Update price column

I have a table SSGPR100 with a SSG_Customer_Price column and I want to reduce the price by 20 percent using an update
0
skull52
Asked:
skull52
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
UPDATE SSGPR100
SET  SSG_Customer_Price = SSG_Customer_Price * .8
0
 
David ToddSenior DBACommented:
Hi,

The above will reduce all prices.

If you want to filter it by some condition, then add a where clause.

Regards
  David
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now