Maximum stored procedure, function, trigger or view nesting level exceeded (Level 32)

Question

Maximum stored procedure, function, trigger or view nesting level exceeded (Level 32)

Viewing 4 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

ajaykini (11/10/2008)
Barry:
CTE works in sql 2005 and not in sql 2000 i guess.
I am having sql 2k as back end.
What is your advise

If you post in a SQL Server 2005 forum, you can expect to get a SQL Server 2005 solution.

steveb. SSC-Forever Points: 46733 More actions · Answer 2

ajaykini (11/10/2008)
Barry:
CTE works in sql 2005 and not in sql 2000 i guess.
I am having sql 2k as back end.
What is your advise

Post this is the 2K forum.

Jeff Moden SSC Guru Points: 1004641 More actions · Answer 3

Continued at the following... on the 2k forum...

http://www.sqlservercentral.com/Forums/Topic599997-169-1.aspx

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

RBarryYoung SSC Guru Points: 143329 More actions · Answer 4

Lynn Pettis (11/10/2008)
ajaykini (11/10/2008)
Barry:
CTE works in sql 2005 and not in sql 2000 i guess.
I am having sql 2k as back end.
What is your advise
If you post in a SQL Server 2005 forum, you can expect to get a SQL Server 2005 solution.

Exaaaaactly, Lynn. 🙂

[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung [font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]