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 |
|
dchan
Starting Member
1 Post |
 Posted - 2011-09-30 : 11:54:28
|
| I want to know how to properly write a “SELECT” statement in SQL 2005 so I can have it give me the sum of two table fields multiplied. For instance I am trying to get the query to basically multiply Price x Quantity. Unfortunately, “SELECT SUM(Quantity * Price)” doesn’t work can anyone help? thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-30 : 11:56:58
|
| it will work. what was error when you tried it?also post used query------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
paultech
Yak Posting Veteran
79 Posts |
|
|
|
|
|
“SELECT SUM(Quantity * Price)” doesn’t work