StringBuilder objSbCommerceRegisterData = new StringBuilder();
            objSbCommerceRegisterData.Append("<?xml version='1.0' encoding='utf-8' ?>");
            objSbCommerceRegisterData.Append("<NewDataSet>");
            foreach (Contrato_CommerceRegister item1 in c_DataCustomer.ListCommerceRegister)
            {
                objSbCommerceRegisterData.Append("  <Table ");
                objSbCommerceRegisterData.Append("      NameRegister='" + item1.CommerceRegister.ToString().Trim() + "' ");
                objSbCommerceRegisterData.Append("      DateIncorporation='" + item1.DateIncorporation.ToString("yyyy-MM-dd hh:mm:ss") + "' ");
                objSbCommerceRegisterData.Append("      Number='" + item1.Number.ToString().Trim() + "' ");
                objSbCommerceRegisterData.Append("      folio='" + item1.folio.ToString().Trim() + "' ");
                objSbCommerceRegisterData.Append("      TakeRegister='" + item1.TakeResgiter.ToString().Trim() + "' ");
                objSbCommerceRegisterData.Append("      AmountCapital='" + item1.initialCapital.ToString().Trim() + "' ");
                objSbCommerceRegisterData.Append("  />");
            }//fin foreach
            objSbCommerceRegisterData.Append("</NewDataSet>");
            StringReader objSrCommerceRegisterData = new StringReader(objSbCommerceRegisterData.ToString());
            DataSet objDbCommerceRegisterData = new DataSet();
            objDbCommerceRegisterData.ReadXml(objSrCommerceRegisterData);

ALTER PROC [common].[uSptJuridicPersonInsertNew]
@IdPerson uniqueidentifier,
@ListCommerce XML,
@IdUser uniqueidentifier
DECLARE @IdCommerceRegister int = 1
IF EXISTS(
SELECT Idperson
FROM [common].[tCommerceRegister]
WHERE Idperson = @Idperson)
    set @IdCommerceRegister = 2
INSERT INTO [common].[tCommerceRegister]
(
 [IdCommerceRegister],
 [NameRegister] ,
 [Idperson],
 [DateIncorporation],
 [Number],
 [folio],
 [TakeRegister],
 [AmountCapital],
 [iduser]
)

SELECT DISTINCT
 @IdCommerceRegister,
 @IdPerson,
 NameRegister = tbl_Tmp_CommerceRegister.Item.value('@NameRegister', 'VARCHAR(50)') ,
 DateIncorporation = tbl_Tmp_CommerceRegister.Item.value('@DateIncorporation', 'DATETIME'),
 Number = tbl_Tmp_CommerceRegister.Item.value('@Number', 'VARCHAR(50)') ,
 folio = tbl_Tmp_CommerceRegister.Item.value('@folio', 'VARCHAR(50)') ,
 TakeRegister = tbl_Tmp_CommerceRegister.Item.value('@TakeRegister', 'VARCHAR(5)') ,
 AmountCapital = tbl_Tmp_CommerceRegister.Item.value('@AmountCapital','DECIMAL(18,2)') ,
 @IdUser

  FROM    @ListCommerceRegister.nodes('NewDataSet/Table')AS          tbl_Tmp_CommerceRegister ( Item )
  WHERE (
      tbl_Tmp_CommerceRegister.Item.value('@NameRegister', 'VARCHAR(50)')+
      CONVERT(VARCHAR(10),tbl_Tmp_CommerceRegister.Item.value('@DateIncorporation', 'DATETIME'),103)+
      tbl_Tmp_CommerceRegister.Item.value('@Number','VARCHAR(50)')+
      tbl_Tmp_CommerceRegister.Item.value('@folio', 'VARCHAR(50)')+
      tbl_Tmp_CommerceRegister.Item.value('@TakeRegister', 'VARCHAR(5)')+
      tbl_Tmp_CommerceRegister.Item.value('@AmountCapital', 'DECIMAL(18,2)')
      NOT IN (
      SELECT
          NameRegister+
          CONVERT(VARCHAR(10),DateIncorporation,103)+
          Number+
          folio  +
          TakeRegister+
          AmountCapital
      FROM [tCommerceRegister] WHERE IdPerson = @IdPerson
    )
 );