I am getting the following error from a for xml stored
proc:

Cannot sort a row of size 8119, which is greater than the
allowable maximum of 8094.

How can i resolve this issue?