Hi All,
We have a xml which contains the node/element name provided by client. After receiving the xml how can we change the node/element value
in SQL server stored proc ?? We have a configuration table where we stored client mapping node values with our mapping node values
For e.g Client XML is as follows.
<Root>
<Parent>
<Authentication>
<ClientDBKey></ClientDBKey>
<ClientSecretKey></ClientSecretKey>
</Authentication>
<Requisition>
<jobPosting>
<ClientJobName> </ClientJobName>
<ClientJobNameTitle></ClientJobTitle>
<ClientJobNameDesc></ClientJobDesc>
</jobPosting>
</Requisition>
</Parent>
</Root>
Should get replaced with the following
<Root>
<Parent>
<Authentication>
<DBKey></DBKey>
<SecretKey></SecretKey>
</Authentication>
<Requisition>
<jobPosting>
<JobName> </JobName>
<JobNameTitle></JobTitle>
<JobNameDesc></obDesc>
</jobPosting>
</Requisition>
</Parent>
</Root>
Any help on this appreciated !