How Do I Solve This Error "Some Part Of Your Sql Statement Is Nested Too Deeply. Rewrite The Query Or Break It Up Into Smaller Queries."

"Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries."

i have 120 query statements in my stored procedure.
I am getting this error when i add another one,it not allow me to write more than 120 query's .i googled it,but it's said to split the query.is there any other way to solve this issue.