/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

15 votes259 views6 answers
Laravel db transaction
SQL
0 vote221 views1 answer
Get created time of database psql 8
SQL
5 votes234 views1 answer
Alter table add comment oracle
SQL
0 vote231 views1 answer
Forcefully delete a row in mysql which has references
SQL
1 vote241 views1 answer
Simple project for database
SQL
0 vote235 views1 answer
Template MySQL Zabbix agent
SQL
0 vote225 views1 answer
Delete insert record in sql server
SQL
13 votes230 views2 answers
Check if value is null mysql
SQL
6 votes260 views4 answers
Mysql group by date
SQL
0 vote275 views1 answer
How to change mysql root password in windows 10
SQL