It was to get the latest + previous purchase per customer...about 40 million out of 60-80 million rows...twice.

Once for current and once for previous.

I have encountered this precise scenario a dozen times.

You can do the same thing with a correlated sub-query, and they usually scale better than any CTE because a CTE is...