[beart]

Would a cross apply accomplish the same result without the risk of multiple rows?

Cross apply (select top 1 ... ) x