Aus einem anderen Forum folgendes Select:


Select 'Item' As RowType,
PartId,
Price
From Part
Union
Select 'Total' As RowType,
0 As PartId,
Sum( Price ) As Price
From Part
Order By RowType,
PartId