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 |
|
joszovko
Starting Member
2 Posts |
 Posted - 2011-08-24 : 04:25:52
|
| I'm trying to calculate percentage of some amount using SQL Server 2008.Let's say I need 50 percent of 700.I tried with "select 700-(700*(50/100))" but I get the result 700.is there any other way to do this or why this query does not work??? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-24 : 04:27:25
|
| select 700.0-(700.0*(50.0/100.0))------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
joszovko
Starting Member
2 Posts |
Posted - 2011-08-24 : 05:44:03
|
| Thanks. It was helpful. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-08-24 : 05:45:18
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Problem calculating percentage