I have a big payload with 400 data like this :
How can I convert this payload to have a query like this:
insert into data1 values ('DB1.DI0','1','ok'), ('DB1.DI4','2','ok'), ('DB1.DI8','3','ok'), ('DB1.DI12','4','ok'), ... and so on.
I have try to split my payload into multiple message and create a query for each message, this is working but I have too much data and some data are missing.
SO that's why I want to send only one big query to my MSSQL Server.
Thanks for help