oracle allows 255, i think sqlserver should also allow the same number...

hi,

upto 32 levels we can nest subquery.

Smita.