Need to display output table based on Transaction 1, Transaction 2 and Transaction 3 table.
Yes, you are right, the dates of T3 and T6 are possible same but sometime 2-3 days different.
I will explain more,
The standard transactions are start from T2->T6->T7->T3 ( T's means scan locations). When T2 is scanned, the unique BATCHID will generate for other consecutive transactions (T6,T7 and T3). But sometimes we received T6 before T2 because the scan device at T6 location send data before T2 and T6 carries its old batch id. Once we received T2 after T6, it initializes new batch id for remaining transactions (T2,T7,T3) and T6 is separated from this transaction logically due to the different
BATCHID but in real its NOT.
The main purpose of this query is to identify missing T6 scan or T7 scan (which is quite normal) where there is T2 scan. We might capture T6 (received before T2) by checking the latest scan date of last T3 (by matching barcode).
Please help me out.
25 People are following this question.