Iterating and comparing rows

Hi danextian,

The logic is to rank by due date, then check if a higher prioirity task is not ontime and if so promote it up the ranks.

For ID 7 they are ranked by due date, and the higher priority task is on time, so no changes are needed.

I've played out the example process for ID 5 below.

STEP 1 - Sort by due date 

STEP 2 - Iterate and check whether on time, promote if needed. 

EG.

Row 2, ONTIME = N, so check whether Row 2 is a higher priority than Row 1. 

900 > 200 so move Row 2 up rank. 

Then EG 

Row 3, ONTIME = N, so check whether Row 3 is higher priority than Row 2.

Priority 500> 200, so move Row 3 up rank

ONTIME still = No

Check whether higher priority than Row 1

Priority 500 < 900 so do not move higher.

Finished iteration of ID5