SQL issue: The maximum number of nested layers exceeded for a stored procedure, function, trigger, or view (maximum number of layers is 32)

1. The source code for the problem is as follows:

 create procedure P4  @avggrade int asselect CNO, avg (Grade ) from Scgroup by Cnohaving avg ( Grade) >  @avggrade  @avggrade = 80                 

Although no error, but run a lot of results come out

Solve:

CREATE PROCEDUREP4@avggrade int  asSELECTCNO,AVG(grade) fromSCGROUP   byCNO having  AVG(grade)> @avggrade GOEXECUTEP4@avggrade =  the

Add a go after the storage process ..... Although I do not know why ...

Reference article:

Http://www.cnblogs.com/furenjun/archive/2008/03/12/sqlerror.html

SQL issue: The maximum number of nested layers exceeded for a stored procedure, function, trigger, or view (maximum number of layers is 32)