Here is the scenario: If the employee transaction is continuous display as-is. if the employee got any gap display as a new row. Below is the sample table Emid Fromdate Todate ----- -------- ...
I'm having a hard time describing my problem and finding it via google. I want to be able to group rows based on location and employee, but the group should be split if a row with the same location ...