/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

8 votes207 views6 answers
Insert command in sql
SQL
7 votes174 views4 answers
What is my mysql version
SQL
23 votes165 views6 answers
Create table sql
SQL
13 votes171 views2 answers
Oracle select into and inner join
SQL
13 votes184 views6 answers
Mysql remove duplicates
SQL
0 vote164 views1 answer
Add column to table with default value plsql
SQL
0 vote181 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote176 views2 answers
SQL BULK INSERT
SQL
0 vote180 views1 answer
Sql declare variable single line
SQL
0 vote168 views1 answer
Get who is hired in specific month in sql
SQL