Error while get data from stored procedures (MSSQL). Unable to use "insert into" statement in stored procedure (MSSQL). Created a temp table to get data from multiple table to process data. While using this procedure in BarTender we are facing error "connection closed". After doing some trail and error method, we came to know that "insert into" syntax is causing the error. When commented out this line it is working fine. Please suggest the way to fix this issue. Thanks in advance.