[SQL] SQL statement is nested too deply

#HB · 07/08/2018, 00:37

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

AceSpace · 07/08/2018, 01:45

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?

If you don't want to share, search on google for this error.

#HB · 07/08/2018, 01:53

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

I sent it to you in private.

AceSpace · 07/08/2018, 04:02

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

Code:

https://pastebin.com/2ufHvPLA

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