[SQL] SQL statement is nested too deply

Have anyone got an idea about this error?

I had like 1954 lines in procedure, I reduced them to 501 and I still get that error.

The weird thing is that I get it at the same line after reducing lines!

SQL version: 2014 x64 ENU

Quote:

Originally Posted by #HB Code: Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries. Have anyone got an idea about this error? I had like 1954 lines in procedure, I reduced them to 501 and I still get that error. The weird thing is that I get it at the same line after reducing lines! SQL version: 2014 x64 ENU  Spoiler Code: Msg 191, Level 15, State 1, Procedure _PvPerzModuleSwitcher1, Line 501 Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.

Maybe we can help if you share the procedure? :rolleyes:
If you don't want to share, search on google for this error.

Well, I can't throw my procedure just like this after writing about 2k lines.

I sent it to you in private.

I helped the user and re-wrote his procedure which had very bad performance and design.

This code is pretty usable for model switchers, just change some stuff here n there and its great.