Help with OLAP query

I am trying to work out an olap query to allocate parts in stock to
customer orders.

Imagine to have a purchase order table like this:

OrderID, PartNumber, QtyOrdered

and a stock table like this

LotID, PartNumber, QuantityOnHand

( a part number can be present in stock with different LotId, customer
does no care to receive different lots for a given part number on
order)

I need to work out a query that allocate each LotID to customers
orders:

OrderID, PartNumber, QtyOrdered, LotID, QuantityAllocated

obviously the total quantity allocated must not exceed QuantityOnHand.

Any help really appreciated.

On Sep 10, 11:28*am, Massimiliano Campagnoli
wrote:
> I am trying to work out an olap query to allocate parts in stock to
> customer orders.
>
> Imagine to have a purchase order table like this:
>
> OrderID, PartNumber, QtyOrdered
>
> and a stock table like this
>
> LotID, PartNumber, QuantityOnHand
>
> ( a part number can be present in stock with different LotId, customer
> does no care to receive different lots for a given part number on
> order)
>
> I need to work out a query that allocate each LotID to customers
> orders:
>
> OrderID, PartNumber, QtyOrdered, LotID, QuantityAllocated
>
> obviously the total quantity allocated must not exceed QuantityOnHand.
>
> Any help really appreciated.

I'm not sure I understand the question. What have you tried, and what
is wrong with it?


/Lennart