Suggestions on writing a pipeline that....

Any suggestions on a pipeline that searchs thru a table looking for a record with a date, capturing a number value in that record and then searching the same table for a record with the next date (ne...