/SQL/Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.

Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.

DECLARE @StudentGrades TABLE (
    [StudentID]          INT,
    [StudentName]        VARCHAR(100),
    [Grade]              DECIMAL(4, 1)
)

INSERT INTO @StudentGrades ( [StudentID], [StudentName], [Grade] )
EXECUTE [dbo].[usp_GetStudentGrades] 1
GO

Source: sql-server-helper.com

Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.

DECLARE @StudentGrades TABLE (
    [StudentID]        INT,
    [StudentName]      VARCHAR(100),
    [Grade]            DECIMAL(4, 1)
)

INSERT INTO @StudentGrades ( [StudentID], [StudentName], [Grade] )
EXECUTE [dbo].[usp_GetStudentGrades] 1
GO

Source: sql-server-helper.com

Similar codes

1 vote352 views1 answer
Psql view enum values
SQL
1 vote287 views1 answer
Database run
SQL
0 vote388 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
0 vote344 views1 answer
T-sql email validation
SQL
0 vote337 views1 answer
Sqlcmd no headers
SQL
0 vote308 views1 answer
Stop psql server windows
SQL
0 vote314 views1 answer
Mysql select all where count more than"
SQL
1 vote322 views1 answer
How to update date add hours in postgresql
SQL
-1 vote355 views1 answer
Mysql faster insert
SQL
6 votes306 views3 answers
Mysql server is not starting xampp
SQL