SQL Server Performance Forum – Threads Archive

How to generate an additional field

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 | 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 | SmallInteger The above database is running on Microsoft SQL Server 2000 and i would like to query
for 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?

---

Sure. Use the expression mentioned in column list of the select query. How much are you willing to pay for basic sql lessons?

---

Look for derived tables in sql server help file Madhivanan Failing to plan is Planning to fail

---

]]>