Search results for query: *

i am viewing it in ie and it is just coming back all together without the tags.

that is how it appears in a browser but if i do view source i will see the original xml. how can i get the text version that had the duplicates removed?

Thanks for your reply. Both methods work fine but what i'm having trouble with is getting the output to have all my xml tags etc so rather than <Pupils> <Pupil pupilid="20"> <Name>Test test</Name> .... i'm just getting 20testtest am i missing something obvious?

Thankyou for your reply. I have looked into this method and I have a few questions. The example matches by an element where I want to match by attribute (pupilid), how would I do that do I just need the @ infront? Also I want to return XML that is exactly the same as the original minus the...

I have an XML file that has duplicate record in it. In SQL Server I would do a SELECT DISTINCT. How can I achieve this with XML. For example <Pupils> <Pupil pupilid="20"> <Name>Test test</Name> </Pupil> <Pupil pupilid="19"> <Name>Test Pupil</Name> </Pupil> <Pupil pupilid="20"> <Name>Test...