xml column to SQL table

UserId

Name

CompanyInfo

1

Johny

<XF1:ParentTransactionModel xmlns:XF1="http://schemas.testcontract.org/2004/07/Trade.Shared.ViewModels.Warehouse">

      <XF1:TradeContractNumber xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"     xsi:nil="true"/>

      <XF1:AgentNumber>1017412</XF1:AgentNumber>

      <XF1:AgentAddress1>PO Box 19150</XF1:AgentAddress1>

      <XF1:AgentCity>Agent City</XF1:AgentCity>

      <XF1:Companies>

            <XF1:ChildCompanyModel>

                  <XF1:ChildAgentNumber>2017412</XF1:ChildAgentNumber>

                  <XF1:ChildAgentAddress>PO Box 29150</XF1:ChildAgentAddress>

                  <XF1:ChildAgentCity>Child City</XF1:ChildAgentCity>

            </XF1:ChildCompanyModel>

      </XF1:Companies>

<XF1:PremiumBaseDifference>2000</XF1:PremiumBaseDifference>

</XF1:ParentTransactionModel>

2

Harry

<XF1:ParentTransactionModel xmlns:XF1="http://schemas.testcontract.org/2004/07/Trade.Shared.ViewModels.Warehouse">

      <XF1:TradeContractNumber xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nil="true"/>

      <XF1:AgentNumber>1017413</XF1:AgentNumber>

      <XF1:AgentAddress1>PO Box 19151</XF1:AgentAddress1>

      <XF1:AgentCity>Agent City1</XF1:AgentCity>

      <XF1:Companies>

            <XF1:ChildCompanyModel>

                  <XF1:ChildAgentNumber>2017413</XF1:ChildAgentNumber>

                  <XF1:ChildAgentAddress>PO Box 29152</XF1:ChildAgentAddress>

                  <XF1:ChildAgentCity>Child City1</XF1:ChildAgentCity>

            </XF1:ChildCompanyModel>

      </XF1:Companies>

      <XF1:PremiumBaseDifference>2000</XF1:PremiumBaseDifference>

</XF1:ParentTransactionModel>

UserId

User Name

AgentNumber

AgentAdress

AgentCity

1

Johny

1017412

PO Box 19150

Agent City

2

Harry

1017413

PO Box 19151

Agent City1

UserId

User Name

ChildAgentNumber

ChildAgentAdress

ChildAgentCity

1

Johny

2017412

PO Box 29150

Child City

2

Harry

2017413

PO Box 29152

Child City1