Passing XML to be styled from SQL Database xml field

I have an application that retrieves data from a webservice and then saves to SQL database and then now i need to retrive that data and display it in a Web page and I want to style it accordingly. I get to a problem as some of the xml nodes repeat themselves and they have no ids and i was wondering if there is a work around to this when using softeware as Altova StyleVision. Sample XML

0100101645511420ROBERTSONNEILEDWINMRM20151123195007175007175043082DDIVORCED02H(011)4531247 B(011)614657000000000076730068964551142001161465702009061900060114524800200210240006000000000000011453124720100614000500000000000000000000000000000000000767300689201006140005000000000000000000000000000000000000000000000000000000000000000002224010010164551142020100614COLLIES CLOTHING00020010164551142020031221MANAGERMASS SUPPLY CLOTHING00030010164551142020000622DIRECTOR00

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tumelo Molefe10y ago
Could You Please guide me on how to go about it when retrieving and saying the file so it saves like a regular XML File
0
Manas Mohapatra10y ago
In above XML which node value you are trying to get but not able get. Please provide details.
0