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?