Cannot insert multiple records in Tabletmp The insert_recordset operation cannot be performed due to an internal error.

Hi All,

There is a requirement where I have a while select loop in ProcessReport() method of an SSRS report. To improve the performance of the code, I converted the while select code to Insert_recordset with proper selects and joins. But then, when I try executing the report, I get the above error : “Cannot insert multiple records in TempTable”.

This issue comes for all table types here.

When I change the Table type to Regular and try running the report, the error is the same but an additional log comes with it:

Cannot insert multiple records in Tabletmp . ColumnName: 0.

The SQL database has issued an error.

SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name ‘F17’


Please share some screenshots of your error and more details on it.

The above highlighted in red is the error that I am getting through the infolog