0 Replies Latest reply: May 6, 2011 2:54 AM by Reignfire RSS

    determine the right division for each request in script

      Hi,

       

      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
      big files?

       

      Pls help thx