declare @sql_string NVARCHAR(255), @parm_def NVARCHAR(255),@file_name varchar (255),@id_dom INT,
@xml_str VARCHAR(MAX), @xml xml

		select @xml='<?xml version="1.0" encoding="UTF-8"?>
		<?xml-stylesheet type="text/xsl" href="C:\SDBEB\rest_mt535_02.xslt"?><?xml-stylesheet type="text/xsl" href="https://www.besteffortsbank.ru/ru/depobsl/ras_dep/rest_mt535_02.xslt"?>
<CustMessages xmlns="CustMessages" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="CustMessages CustMessages.xsd">
  <AppHdr xmlns="urn:iso:std:iso:20022:tech:xsd:head.001.001.01">
    <Fr>
      <OrgId>
       <Nm>Some Bank</Nm>
        <Id>
          <OrgId>
            <AnyBIC>SOMERUMM</AnyBIC>
          </OrgId>
        </Id>
      </OrgId>
    </Fr>
    <To>
      <OrgId>
      <Nm>111</Nm>
        <Id>
          <OrgId>
            <Othr>
              <Id>SOMEBANKID</Id>
              <SchmeNm>
                <Prtry>XXXBank</Prtry>
              </SchmeNm>
            </Othr>
          </OrgId>
        </Id>
      </OrgId>
    </To>
    <BizMsgIdr>A123321</BizMsgIdr>
    <MsgDefIdr>semt.002.001.02</MsgDefIdr>
    <CreDt>2019-12-25T08:28:27.04Z</CreDt>
  </AppHdr>
  <Document xmlns="urn:iso:std:iso:20022:tech:xsd:semt.002.001.02">
    <CtdyStmtOfHldgsV02>
      <MsgId>
        <Id>R123321</Id>
        <CreDtTm>2019-12-25T11:28:27.447</CreDtTm>
      </MsgId>
      <MsgPgntn>
        <PgNb>1</PgNb>
        <LastPgInd>true</LastPgInd>
      </MsgPgntn>
      <StmtGnlDtls>
        <Ref>R96336</Ref>
        <StmtDtTm>
          <Dt>2019-12-24</Dt>
        </StmtDtTm>
        <Frqcy>
          <FrqcyAsCd>DAIL</FrqcyAsCd>
        </Frqcy>
        <UpdTp>
          <StmtUpdTpAsCd>COMP</StmtUpdTpAsCd>
        </UpdTp>
        <ActvtyInd>true</ActvtyInd>
        <StmtBsis>
          <StmtBsisAsCd>SETT</StmtBsisAsCd>
        </StmtBsis>
      </StmtGnlDtls>
      <AcctDtls>
        <Id>
          <SmplId>
            <Prtry>
              <Id>ANB33333</Id>
            </Prtry>
          </SmplId>
        </Id>
        <FngbInd>true</FngbInd>
        <AcctOwnr>
          <NmAndAdr>
            <Nm>222</Nm>
          </NmAndAdr>
        </AcctOwnr>
      </AcctDtls>
      <SubAcctDtls>
        <Id>
          <SmplId>
            <Prtry>
              <Id>B22111</Id>
            </Prtry>
          </SmplId>
        </Id>
        <FngbInd>true</FngbInd>
        <ActvtyInd>true</ActvtyInd>
      </SubAcctDtls>
      <SubAcctDtls>
        <Id>
          <SmplId>
            <Prtry>
              <Id>T99888</Id>
            </Prtry>
          </SmplId>
        </Id>
        <FngbInd>true</FngbInd>
        <ActvtyInd>true</ActvtyInd>
        <BalForSubAcct>
          <AggtQty>
            <Qty>
              <Unit>1.00000000</Unit>
            </Qty>
          </AggtQty>
          <AvlblQty>
            <Qty>
              <Unit>1.00000000</Unit>
            </Qty>
          </AvlblQty>
          <FinInstrmDtls>
            <Id>
              <ISIN>US123321654</ISIN>
            </Id>
          </FinInstrmDtls>
        </BalForSubAcct>
      </SubAcctDtls>
    </CtdyStmtOfHldgsV02>
  </Document>
</CustMessages>'


    EXEC sp_xml_preparedocument @id_dom OUTPUT, @xml

  SELECT * from OPENXML (@id_dom,'CustMessages/AppHdr/Fr/OrgId')
    with (NM varchar(255) 'Nm' )
   
    EXEC sp_xml_removedocument @id_dom