如何将SQL中的循环转换为基于集合的逻辑

I have spent a good portion of today and yesterday attempting to decide whether to utilize a loop or cursor in SQL or to figure out how to use set based logic to solve the problem. I am not new to set logic, but this problem seems to be particularly complex.I have spent a good portion of today and yester