Problem>> Dynamic sql query in stored procedure error could not figure out ?
or
Dynamic sql query in stored procedure MAX length error ?
or
How to break dynamic sql query into parts?

Solution>> SET @sqlPART1='First half of your dynamic query which is less than 4000 characters '
SET @sqlPART2='Second half of your dynamic query which is less than 4000 characters '

EXEC(@sqlPART1+@sqlPART2)