Presumably you can only have one completed?
Thank you so much Alex, that did the trick.
To complicate matters more... sometimes, data might get lost leaving a row abandoned. In order to weed out bad data, I was hoping to do something like:
if max([GEN_TS_LCT])=window_max(max([GEN_TS_LCT])) and isnull([END_TIME_TS_LCT]) and (1500 < datediff('second', [START_TIME_TS_LCT], now())) then
elseif max([GEN_TS_LCT])=window_max(max([GEN_TS_LCT])) then
Is this possible?