Gregory Jones
10/20/2021, 9:48 PMKEEP(DENSE_RANK FIRST...)
for the oldest value. Could have just done case statement for when it was set and then brought in the current value for the other column and been done with it. Sometimes I just like finding alternate ways of doing things.