AnsweredAssumed Answered

Overcome SQL 200 Row Limitation?

Question asked by borisj on May 6, 2016



I'm looping through a collection with a for each (line from CSV) then inserting via an SQL query - however, the inserts cease at 200, in line with the documentation stating that 200 is the maximum. The documentation also states this can be overcome by updating the query, but the values if the query are updated in every cycle of the loop.


Any ideas would be appreciated, thanks!