/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 vote323 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote297 views1 answer
Sql row number in result set
SQL
0 vote404 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
2 votes299 views2 answers
How to view created temporary tables in mysql
SQL
13 votes300 views2 answers
Mysql order by multiple columns
SQL
4 votes298 views3 answers
Mysql modify foreign key
SQL
1 vote298 views1 answer
Sql server get users
SQL
13 votes301 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
1 vote317 views1 answer
Alter add syntax
SQL
1 vote308 views2 answers
How to search date in sql query
SQL