title: Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)
body: <p>I am creating a store procedure but while executing the procedure i am getting the particular error.</p>
  
  <p><strong>Msg 217, Level 16, State 1, Procedure SendMail_Renewapp, Line 77
  Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).</strong></p>
  
  <p>Can anyone please help me out from this problem.</p>
  
  <p>My procedure is as follows..</p>
  
  <pre><code>`ALTER PROCEDURE [dbo].[SendMail_Renewapp] 
  -- Add the parameters for the stored procedure here
  
  AS
  BEGIN
  declare @xml nvarchar(max)
  declare @body nvarchar(max)
  declare @currentdate datetime;
  declare @ExpDate datetime;
  declare @mailsendingdate datetime;
  declare @renewtime varchar(10);
      DECLARE @AgencyId int;
  DECLARE @ApplicationID int;
  declare @emailid varchar(100);
  
  set @currentdate=getdate();
  
  
                  --Fetching the application details: start--
                  DECLARE AppCursor CURSOR FOR 
                  Select top 5 applications.ap_id,applications.ap_expiry_date,agency.ag_co_email from applications  join agency on applications.ap_agency_id=agency.ag_id
                   where ap_status='AS' and ap_iame_flag='IA' and ap_expiry_date != '' 
                      OPEN AppCursor
                      FETCH NEXT FROM AppCursor INTO @ApplicationID,@ExpDate,@emailid
  
                      WHILE @@FETCH_STATUS = 0 
                      BEGIN
  
                       SET @renewtime = ABS(DATEDIFF(day, @currentdate, @ExpDate))
                              if(@renewtime=180)
  
                                  BEGIN
  
                                      --SET @xml = CAST(( SELECT [ag_id] AS 'td','',[ag_name] AS 'td','',[ag_co_email] AS 'td','',[ag_mobile] AS 'td'FROM  beesl.dbo.Agency where @renewtime &lt; 180
  --FOR XML PATH('tr'), ELEMENTS ) AS NVARCHAR(MAX))
  
  SET @body ='&lt;html&gt;
  &lt;body&gt;
     &lt;div&gt;
  &lt;div&gt;
  &lt;H3&gt;Agencies Details whose payment are still pending for last 3 months&lt;/H3&gt;
  &lt;/div&gt;
  &lt;table cellpadding="4" cellspacing="1" bgcolor=#FFFFFF   border=1 rules=none frame=box  &gt; 
  &lt;tr  &gt;
  &lt;th style=border:1px solid #000000;  align=left bgcolor=#c2c2c2&gt; Agency ID &lt;/th&gt;
   &lt;th style=border:1px solid #000000;  align=left bgcolor=#c2c2c2&gt; Agency Name &lt;/th&gt; 
  &lt;th style=border:1px solid #000000;   align=left bgcolor=#c2c2c2&gt; Agency Email &lt;/th&gt; 
  &lt;th style=border:1px solid #000000;   align=left bgcolor=#c2c2c2&gt; Contact Number &lt;/th&gt; 
  
  &lt;/tr&gt;'   
      SET @body = @body + @xml +'&lt;/table&gt;&lt;/div&gt;&lt;/body&gt;&lt;/html&gt;'
  
  EXEC msdb.dbo.sp_send_dbmail 
  @profile_name='BEE', 
  @recipients='emailid@emailid.com', 
  @subject='Renew Applications',
  --@file_attachments = 'D:\beelogo.png',
  @importance= High,
  --@body = 'Testing'
  @body = @body,
  @body_format ='HTML';
  
                                  END
  
  
                      FETCH NEXT FROM AppCursor INTO      @ApplicationID,@ExpDate,@emailid
                  END
                      CLOSE AppCursor
                      DEALLOCATE AppCursor
                  --Fetching the application details: end--
  
  
    END`
  </code></pre>