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.
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. |
|
|
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? |
|
|
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)_! |
|
|
saint_izzy
Starting Member
3 Posts |
Posted - 2014-02-25 : 13:20:29
|
Thank you! I was able to figure it out. |
|
|
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 amountMadhivananFailing to plan is Planning to fail |
|
|
|
|
|