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’