My procedure has large query syntax ,many "nested if else" when i create it on one SQL server server get below error:
Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.
but when i create that on another server,that is created without error ,i know the procedure has poor performance but why that is created correctly on another server
Does it depend on server config or database feature ?