https://community.blueprism.com/t5/Product-Forum/Able-to-add-rows-collection-into-table-of-MSsql-database/m-p/59052#M12784 Hi Blue Prismian, I would to able to insert multiple rows of collection into a table of database MSSql (not one by one with loop because it's more slow). I create an action for execute query. My query is: "INSERT INTO Table(Type,Id) VALUES( (SELECT campo FROM Collezione output) ,'"&[Id]&"');"   "Id" is an int variable. "Collezione output" is the collection that i would insert into database. "campo" is a text value of Collection output. the message error is :Incorrect syntax near output Can you help me, please?Any solutions alternative will be appreciate :) Do you  have improve code (c# or another) for to do this? Thanks.   Thu, 28 Jun 2018 19:32:00 GMT GM 2018-06-28T19:32:00Z https://community.blueprism.com/t5/Product-Forum/Able-to-add-rows-collection-into-table-of-MSsql-database/m-p/59052#M12784 Hi Blue Prismian, I would to able to insert multiple rows of collection into a table of database MSSql (not one by one with loop because it's more slow). I create an action for execute query. My query is: "INSERT INTO Table(Type,Id) VALUES( (SELECT campo FROM Collezione output) ,'"&[Id]&"');"   "Id" is an int variable. "Collezione output" is the collection that i would insert into database. "campo" is a text value of Collection output. the message error is :Incorrect syntax near output Can you help me, please?Any solutions alternative will be appreciate :) Do you  have improve code (c# or another) for to do this? Thanks.   Thu, 28 Jun 2018 19:32:00 GMT https://community.blueprism.com/t5/Product-Forum/Able-to-add-rows-collection-into-table-of-MSsql-database/m-p/59052#M12784 GM 2018-06-28T19:32:00Z https://community.blueprism.com/t5/Product-Forum/Able-to-add-rows-collection-into-table-of-MSsql-database/m-p/59053#M12785 Hello GM, By seeing your query, as ""id"" is int column and you are sending as string. Please try with below query please find an attachment for query Hope it will work :) Thanks & Regards, Vijay Rudrappa Dodamani Tue, 30 Oct 2018 12:10:00 GMT https://community.blueprism.com/t5/Product-Forum/Able-to-add-rows-collection-into-table-of-MSsql-database/m-p/59053#M12785 VijayDodamani 2018-10-30T12:10:00Z