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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-10 : 09:09:15
|
| Gamil Rasmy writes "I have table and I want to calcutate (qnty*price) for each row. then the result to be multipled by 10%,then the result evaluated be case statmen to retrive another value.here is what I need in select statmentsubtotal = qnty*priceTotal = subtotal*1.1case totalwhen > 100 Gtotal = totalwhen <100 Gtotalend as gtotal" |
|
|
|
|
|
Caluculated fields