[fdtoo]

I have the following fields in table A:

 GL_ID|GL_Name_VC|     Amount    |Period_TI|Year_SI|
===================================================
  1000|  Software|    2,000.00   |  01     |  2005
===================================================
  1000|  Software|    2,000.00   |  01     |  2005
===================================================
  1000|  Software|    5,000.00   |  02     |  2005
===================================================
  1000|  Software|    5,000.00   |  02     |  2005
==================================================
  1001|  Hardware|   10,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       | 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:

Description      | Hardware  |  Software  | Total
====================================================
Opening Balance  |    0.00   |  4,000.00  | 4,000.00
Period 02        | 10,000.00 | 10,000.00  |20,000.00
====================================================
Closing Balance  | 10,000.00 | 14,000.00  |24,000.00

The above report has 4 columns, with 1st & last column being a calculated field.
Notice that the Opening Balance description is a sum of all amount under period 01,
with software having a total Opening Balance of 4,000.00 (2,000.00 + 2,000.00).
The amount for both Hardware & software are group by period 02, and a Closing Balance
is derived by adding the sum of Period 01 & Period 02.Total column is a summation of
both Hardware & Software amount.

Guys, hope someone out there can help me with the sql command for the above report?

[coderzone]

Reply to How to split a field into two fields will solve this query as well.