/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 vote129 views1 answer
Psql datestyle
SQL
1 vote139 views1 answer
Postgres convert date to string
SQL
0 vote125 views1 answer
Tsql generate rows
SQL
2 votes160 views1 answer
Revokeprivileges mysql
SQL
5 votes129 views1 answer
Sysdate in oracle sql
SQL
0 vote132 views4 answers
Sql year
SQL
0 vote143 views1 answer
Proc sql not in working
SQL
0 vote133 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
5 votes161 views3 answers
Show indexes mysql
SQL
0 vote126 views1 answer
Edit a field mysql terminal
SQL