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-08-02 : 09:00:48
|
| Rihard writes "I have a problem (or I think I do). In a table I have the following fields:Product_ID/Qtty/Price10/10/20,0010/5/15,0010/6/18,00now I need two more fields, which perform certain calculations on those existing fields in that table:Product_ID/Qtty/Price($)/Stock(Qtty)/Stock($)10/10/20,00/10/200,0010/5/15,00/15/275,0010/6/18,00/21/383,00I tried a few things (views, stored procs), but nothing worked properly. I must admit, I din't spend much time on this, because I have a million other problems to solve, so I figured, you guys could help me out on this!? Thanks!" |
|
|
|
|
|
|
|
Row calculations