/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 vote275 views1 answer
Get sum sqlite android
SQL
1 vote265 views3 answers
How to update column name in psql
SQL
1 vote256 views1 answer
Count of tables in database mysql
SQL
6 votes246 views1 answer
Sqlite foreign key
SQL
24 votes270 views6 answers
Replace mysql
SQL
2 votes308 views1 answer
Postgresql group by month and year
SQL
0 vote257 views1 answer
T-SQL Retry (deadlock)
SQL
0 vote299 views1 answer
Sql to excel pgadmin
SQL
0 vote252 views1 answer
Hibernate with springboot mysql
SQL
0 vote255 views1 answer
Laravel general error 2006 mysql server has gone away
SQL