• That query willl not handle that scenario. We can work it out anyways. Do u have any "Shift identifier"??