rollcall- | winforms program developed with c # , realizes random roll

Just change your reading part to this:

As the essence of all your passed questions I pick

• There are many xml files in the same directory (well, many in one and many in another)
• All files have the same structure
• You want to read them into a table

My Assumptions (which you have to adapt to your needs)

• The names are computable (in my case "xml1", "xml2", "xml3" ...)
• For my testscenario I created three XML files (called "xml1.xml", "xml2.xml" and "xml3.xml" with the content of your baby version. Therefore the loop stops at 4

Try this

• I create a staging table with the fitting structure (do not bother about datetime conversion in this first step!)
• I use a counter to compute the file's name within a loop
• I use a WHILE loop
• Within this loop the full statement is dynamically created. It will read your XML from the file into a variable and push all the values into the table.
• With EXEC this command is executed
• Check the result with a simple SELECT

This is the code

Create a datetime field in the [dbo].[staagingTable]

and modify the insert query for that new field and populate it with CONVERT(datetime,'action-date[1]'+' '+action-time[1] , 100)