• No we don't have VARCHAR(MAX) in our DB. Even I know that's not the issue but this is something which I want to know why this problem is solved because of removing CTE's.