Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 need help

Author  Topic 

saint_izzy
Starting Member

3 Posts

Posted - 2014-02-24 : 22:43:22
how can I write this?? The last part of the sentence below.

the price of "FRESH SALAD" is currently $2.00. The new price should be 10% greater, or $2.20. The price increase should be $0.20, the difference between the new and old prices.

saint_izzy
Starting Member

3 Posts

Posted - 2014-02-24 : 23:02:38
how do i identify the difference between my old price $2.00 and the new price $2.20. I need to identify the 0.20 in a separate column.
Go to Top of Page

Mar
Starting Member

47 Posts

Posted - 2014-02-25 : 08:20:23
What are you trying to do exactly besides get someone else to do your homework?
Go to Top of Page

maunishq
Yak Posting Veteran

71 Posts

Posted - 2014-02-25 : 12:24:18
SELECT Old_Price, (Old_Price*0.1) AS [pc10] FROM table_name


!_(M)_!
Go to Top of Page

saint_izzy
Starting Member

3 Posts

Posted - 2014-02-25 : 13:20:29
Thank you! I was able to figure it out.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2014-02-26 : 06:58:11
quote:
Originally posted by saint_izzy

Thank you! I was able to figure it out.


What is the solution?

If the format is same you can parse the string based on the value "The price increase should be " and extract the amount

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -