Very interesting on the elapsed times... I would have figured I would have been the quickest without having to perform a table join, but I guess either the partition...
Nice ideas - I work in the insurance industry and use this often to look for out-of-sequence endorsements and transactions. Here's another way to acheive it, without a join.