I am trying to check to see if the value for column 'complete' of is less than the startDate and if it is then I need to set the startDate to that value so the row is included in the return set....
In looking at the data set here:
Table and code testing
I have several things not working as I would like
1. row 12 isError should = 1 as row 12 and row 13 are both actiivtyID 1257
2. if row 10 is the FIRST row returned in a select statement (using a where date between start and end) I need to set the start date to row 10's completed value