Limit on inserts 1000 error in sql server

[maximnl]

Sql server limits number of rows that can be inserted in a single insert to 1000 rows

solution enclose the value block into

SELECT * FROM ( VALUES (...), (...) ) as TEMP (col1 ,col2,col3...)