The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values

Error message:

The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values.

Problem:

As written...  INSERT statement exceeds the maximum allowed number of 1000 row values.

Surprised, but INSERT statement using 'VALUES' (not insert with a select) - have limitation of 1000 inserted records.

Solution:

Anything that will use INSERTs with maximum 1000 records: separate to few INSERTs, insert the new data to temp table and insert using select from the temp table and so on.