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 |
|
fdtoo
Starting Member
28 Posts |
 Posted - 2006-04-11 : 20:20:39
|
| I have the following fields in table A: GL_ID|GL_Name_VC | Amount |Period_TI|Year_SI=================================================== 1000| Inventory| 8,000.00 | 01 | 2005=================================================== 1000| Inventory| -3,000.00 | 02 | 2005=================================================== 1000| Inventory| 5,000.00 | 02 | 2005===================================================the fields above have the following datatype: Fields | Datatype =================================== GL_ID | Integer GL_Name_VC | Variable Character Amount | Integer Period_TI | TinyInteger Year_SI | SmallIntegerThe above database is running on Microsoft SQL Server 2000 and i would like to queryfor a report that looks something as below:GL_ID|GL_Name_VC |Period_01|Period_02 |Total_YTD================================================1000 | Inventory | 8,000 | 2,000 |10,000 Percentage| 10% | 20% | 0================================================ Total | 800 | 400 | 1,200 The Total row is calculated by multiplying the percentage row by the Inventory amount ineach Period.Guys, hope someone out there can help me with the sql command for the above report? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
How to multiply two value from two fields