> I am fairly new at using Firebird SQL and I would like some direction on
> how to include some calculations into my code.
>
> For example I want to read a table, group by a part number and then get a
> total price for all the items in the group. Would this be something for a
> SP?
>
> I have looked online but couldn't find a complete answer.
>
> Thank you for any help/direction that you can give on this.
>

You use what is known as an aggregate query. Aggregate queries are ones
where you use individual columns for the grouping and calculations for those
groups. Something along the lines of:

Select PartNumber, sum(PartCost * PartQty) from Parts
group by PartNumber

This would return a list of distinct part numbers along with their total
costs based on the individual cost times the number of parts. For example,
suppose you have these in the parts table:

PART COST QTY
Widget 1 1.50 3
Widget 1 1.45 5
Widget 2 2.20 1
Widget 2 2.00 3

The result would be:
Widget 1 11.75
Widget 2 8.20


For more complex calculations, it might be necessary to create a stored
procedure but in most cases, queries should do what you want.

HTH
Woody (TMW)