Insert total quantity based on number of transactions

[jtarry]

Hi,

I have two tables

Table a contains

Part Number
A 3
B 1

Table b (transactions)

Serial Part Qty
1 A 2
2 C 1
3 A 1
4 B 2
5 A 1
6 A 2
7 A 1
8 B 1

I need to produce a quantity for part A and B from the transaction table. The lastest entry in the transaction table is Serial 8.

Results need to be:

Part Number Quantity
A 3 4 (serial 7,6,5)
B 1 1 (serial 8)

Ant ideas how I can achieve?

Thanks

 

[markros]

I think you should be able to achieve your result if you'll go through this weblog

http://pratchev.blogspot.com/2010/02/refactoring-ranges.html

PluralSight Learning Library