johncyriac:

Nice. I added a line to see to what level nesting it did:

create proc nest_sp_dec

@kount int

as

begin

select @kount

select @kount=@kount-1

SELECT @@NESTLEVEL AS NESTLEVEL

if @kount >0

exec nest_sp_dec @kount

end

and executed it with:

nest_sp_dec 10

It showed a nest level of 10

and then with

nest_sp_dec 33

which exceeded the max nest level.

Robert W. Marda

SQL Programmer

bigdough.com

The world’s leading capital markets contact database and software platform.