I've thought about the possibility of using CTE and tally tables. Not sure if those would be applicable. Also, I'm definitely looking into removing as much loop as possible as...