How to add large number of records to temp tableHi All,
I am working on a module in which there is a scenario in which I had to add more than 25,000 records to SQL server temp table from VB.NET list using inline SQL queries. Since this is a performance improvement module and it's very complex I've some restrictions to not use stored procedure for the same. If I try to insert values to temp table or table variable using insert into or select into SQL server throws error stating that it can not add more than 1000 rows. So is there any best optimized solution for this kind of problem which can be done using minimal line of code and it will be efficient also. Please let me know if you have any idea on this. Thanks in Advance.
Environment-Visual Studio 2010,VB.NET,SQL Server 2012