Amigos preciso montar uma ER que busque a chave por exemplo “0000088C” e que traga tudo que estiver entre as tags e .
Buscando “0000088C” deve retornar apenas:
[code]
[/code]Buscando “0000087C” deve retornar apenas:
[code]
[/code]Texto Completo
<Package>
 <Header Reason="0" Id="198" Version="1.0"/>
 <Control Provider="" CPRDateTime="2012/02/08 11:58:32" Account="2" MsgId="211" Port="3000"/>
 <TCA ProductId="22" SerialNumber="0000087C" VersionId="0.1"/>
 <Datagram MsgType="STATE" MsgDateTime="2012/02/08 10:58:29"/>
 <GPS SatNum="8" Speed="68" DateTime="2012/02/08 10:58:28" NorthAngle="293.0" AltitudeStatus="VALID" PosIsValid="TRUE" Lat="-25.54156" Long="-48.68713" CableStatus="OK" Altitude="18"/>
 <Comm RSSI="0" GPSType="INTERNAL"/>
 <LinearInput Speed="0" Odometer="0" RPM="0" Temp1="127" BackBattery="40" Temp2="127" Temp3="127" MainBattery="26"/>
 <Input Movement="ON"/>
 <Output/>
 <Event Movement="ON" EventDateTime="2012/02/08 10:58:28"/>
</Package>
<Package>
 <Header Reason="0" Id="198" Version="1.0"/>
 <Control Provider="" CPRDateTime="2012/02/08 11:58:32" Account="2" MsgId="211" Port="3000"/>
 <TCA ProductId="22" SerialNumber="0000088C" VersionId="0.1"/>
 <Datagram MsgType="STATE" MsgDateTime="2012/02/08 10:58:29"/>
 <GPS SatNum="8" Speed="68" DateTime="2012/02/08 10:58:28" NorthAngle="293.0" AltitudeStatus="VALID" PosIsValid="TRUE" Lat="-25.54156" Long="-48.68713" CableStatus="OK" Altitude="18"/>
 <Comm RSSI="0" GPSType="INTERNAL"/>
 <LinearInput Speed="0" Odometer="0" RPM="0" Temp1="127" BackBattery="40" Temp2="127" Temp3="127" MainBattery="26"/>
 <Input Movement="ON"/>
 <Output/>
 <Event Movement="ON" EventDateTime="2012/02/08 10:58:28"/>
</Package>
<Package>
 <Header Reason="0" Id="198" Version="1.0"/>
 <Control Provider="" CPRDateTime="2012/02/08 11:58:32" Account="2" MsgId="211" Port="3000"/>
 <TCA ProductId="22" SerialNumber="0000087C" VersionId="0.1"/>
 <Datagram MsgType="STATE" MsgDateTime="2012/02/08 10:58:29"/>
 <GPS SatNum="8" Speed="68" DateTime="2012/02/08 10:58:28" NorthAngle="293.0" AltitudeStatus="VALID" PosIsValid="TRUE" Lat="-25.54156" Long="-48.68713" CableStatus="OK" Altitude="18"/>
 <Comm RSSI="0" GPSType="INTERNAL"/>
 <LinearInput Speed="0" Odometer="0" RPM="0" Temp1="127" BackBattery="40" Temp2="127" Temp3="127" MainBattery="26"/>
 <Input Movement="ON"/>
 <Output/>
 <Event Movement="ON" EventDateTime="2012/02/08 10:58:28"/>
</Package>Alguém consegue montar esta ER, Obrigado!