How to Relate a Table with Another Table where the field to relate is an XML

1

I'm having a SQL Server database from a system that has been discontinued. In this database, there is a MOVIMENTACAO table and a EQUIPAMENTO table, where you would set a N:N relationship.

The problem is that instead of having a third table, there is a field in the MOVIMENTACAO table with the IDs of the EQUIPAMENTOS in XML format. p>

EX:

<ArrayOfInt xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <int>39254</int>
  <int>39255</int>
  <int>79349</int>
  <int>79351</int>
  <int>79354</int>
  <int>79456</int>
  <int>79539</int>
  <int>79547</int>
</ArrayOfInt>

Doubt: Is there any way to put together a QUERY where I can make this relationship?

    
asked by anonymous 27.11.2018 / 14:22

0 answers