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...)