I am trying to save this XML into a MSSQL database (XML is below).

I have been using this code as a starting point:
<https://www.mssqltips.com/sqlservertip/5707/simple-way-to-import-xml-data-into-sql-server-with-tsql/>

Everything works well (yeah!), except the last field "Transaction\_ID" (bummer...).
The 4 values of the last field are placed after each other in the SQL table. And I would like to have the values in separate records.

This is part of the code I used to convert the last field into MSSQL:

```
MY_XML.XML1.query('Transactions/Transaction_ID').value('.','VARCHAR(255)')

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Root>
<Session>
<Record_ID>000029837OYMV22fdewSY12IuRBUlxqq=</Record_ID>
<Extraction_Date>2020-03-25T14:02:29</Extraction_Date>
<Company_ID>Company1</Company_ID>
<ID>Product2</ID>
<Session_ID>000029837OYMV22fdewSY12IuRBUlxqq=</Session_ID>
<Session_Start_Datetime>2019-11-21T15:21:59</Session_Start_Datetime>
<Session_End_Datetime>2020-05-11T15:26:36</Session_End_Datetime>
<Session_Commission>25</Session_Commission>
<Transactions>
<Transaction_ID>1</Transaction_ID>
<Transaction_ID>2</Transaction_ID>
<Transaction_ID>3</Transaction_ID>
<Transaction_ID>4</Transaction_ID>
</Transactions>
</Session>
</Root>

```

1. is our data model the issue?
2. is the XML we received the issue?
3. is my code the issue?
4. or do I need to save the transaction\_IDs and a key in a separate SQL table?

Thanks!

All the best,
Sharon