Re: How to create Stored Procedure to INSERT multiple Rows in a table

[Hemant Mehta]

Good Morning Peter!
Looking at the link above, the approach seems to be loading a XML file(picking from a location on Server) into a TABLE.
My scenario is
I have created an API on ESB. The consumer calls my API with XML message,
That gets parsed in my ESB and then I need to do multiple INSERTS based on the XML message.
Not Sure if we would be allowed to first convert the incoming message and create a file on Server and then load it using the above steps.

Also, with this function will all subsequent LOAD Append the Data/Rows sequentially? And Table keeps getting enriched with every message