If you are using MSSQL 2008+ you can perform a multi-row insert which looks like this for a single column table:
insert into tblData1 (Item) values (15), (12), (10);
If you have multiple columns to insert:
insert into tblData1 (Item1, Item2) values (15, 10), (12, 7), (10, 5);
So after your split node, you can place a template node with the following simple template:
({{{payload}}})
This will generate (x) for each item in your array, for example (15)
You then can place a join node to concatenate all these together - set the join node to manual and to create a string joined using a comma.
The payload will now be (15),(12),(10)…etc
Then in your mssql node, place the final insert template:
insert into dbo.tblData1 (Item) values {{{payload}}};
If you are using an older MS SQL, then you will need to perform each insert separately. Unfortunately the node-red-contrib-mssql node will give you errors if you try to use it asynchronously (https://github.com/redconnect-io/node-red-contrib-mssql/issues/12), so you will need to build a loop with nodes so the inserts are performed synchronously (see the while pattern on this site: Node-RED Design Patterns. When programming object oriented code… | by Stephen Keep | Node RED | Medium).
If you get stuck, post your flow and we can try to help you out.
