I'm trying to determine for which division the request is made. (inline example in attachment)
START_TS REQUEST_TS 1 TRANSFER_TS 1 REQUEST_TS 2 TRANSFER_TS 2 REQUEST_TS 3 END_TS
So if the request is made between start and transfer1 (REQUEST_TS 1) it has the startDivision ( CB1 ),
if it's between Transfer 1 and 2 (REQUEST_TS 2) it's the division in the transfertable for the first transfer (CB 5).
if it's between Transfer 2 and the END (REQUEST_TS 3) it's the division in transfertable for the second transfer( back to CB1).
It's also possible there are no transfer then it's the startDivision.
How do i create a table with these tables were i can give each request a correct division and will it be possible to do this on
Pls help thx