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:17:12
|
| I have the following fields in table A: GL_ID|GL_Name_VC| Amount |Period_TI|Year_SI|=================================================== 1000| Sales_HW| -20,000.00 | 01 | 2005=================================================== 1000| Sales_SW| -10,000.00 | 01 | 2005=================================================== 1001| Cost_HW | 5,000.00 | 01 | 2005=================================================== 1001| Cost_SW | 5,000.00 | 01 | 2005the 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:Sales Category | Sales | Cost | Profit ================================================= HW |-20,000.00 |5,000.00| -15,000.00 SW |-10,000.00 |5,000.00| -5,000.00================================================= Total |-30,000.00 |10,000.00|-20,000.00 The above report have 4 columns, with last column being a calculated field (Sales-Cost)Guys, hope someone out there can help me with the sql command for the above report? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-04-12 : 04:29:12
|
| You need to learn SQL. The last column should be (sales-cost) as Profit. It seems that all of your questions should be done in reportsMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
|
|
How to generate an additional field