/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

0 vote160 views1 answer
Close sql query vb.net
SQL
2 votes170 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote188 views1 answer
SQL Server Splitting a string column into multiple rows, while repeating ID column
SQL
0 vote163 views1 answer
Mysql set column equal to another automatic
SQL
0 vote195 views1 answer
Java spring boot connect to sql server
SQL
0 vote178 views1 answer
Reset keys in sql
SQL
0 vote157 views2 answers
Mysql unique two columns
SQL
0 vote161 views1 answer
Postgresql alter column nullable
SQL
0 vote190 views1 answer
Mysql date without time
SQL
0 vote159 views1 answer
Oracle current timestamp
SQL