Now, I need to traverse in all these nodes and check @Code and @Room values which must be same.
Then, I need to add @Guests and @Units values.
I will exclude those nodes with @Code="RAC"
So, my result set will only be a single node like this:
<Rate Guests="5" Units="2" Code="CP" Room="DLX">
All others need to be deleted.
Hope you understand the problem.
Please give your suggestions urgently.