• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 213
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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