Write multiple rows in database from process

Hello,

Is there a way to insert/update multiple rows ( from an array process variable) using "Query Database" or "Stored Procedure" nodes, but without generating one instance for each row to be inserted/updated?

Thank you.

  Discussion posts and replies are publicly visible

Parents Reply
  • +1
    Certified Lead Developer
    in reply to bryant.st39
    HI I am completely agree with MikeSchmitt and , you can go for any of these 2 approaches mention below:-

    1. Create a additional CDT and map the required properties which you want to persist/update, and use this CDT under Write to Data Store Entity Smart Service.

    2. If you are not interested in creating duplicate CDT, then i recommend, you can go for Stored Procedure where you can combine all the rows ID as String and send that String as input to Stored procedure, and inside stored procedure you can split and write these data into a temporary table, and can update the table accordingly.

    But if you are willing to Perform Insert operation as well, i suggest, you should go for Option-1

    Hope this will help you.
Children
No Data