XSD element update based on another element

• lallen-661487

  Mr or Mrs. 500

  Points: 531

  More actions

  September 4, 2008 at 11:23 am

  #193129

  I'm not sure this is the right forum for an XSD discussion, but it does tie to SQL Server.

  I have an element that I want to update based on information stored in another element. I'm really new to XML, so any advice may point me in the right direction.

  Thanks!

• Abhijit More

  SSCertifiable

  Points: 6897

  More actions

  September 5, 2008 at 12:29 am

  #867579

  WITH XMLNAMESPACES('EmployeeXSD' AS E)

  SELECT

  nref.value ('@DepartmentID', 'int'),

  nref2.value('@EmployeeID', 'int'),

  nref2.value('@Salary', 'money')

  FROM@xml.nodes('/E:Department') AS R(nref)

  CROSS APPLY R.nref.nodes('./E:Employee') AS R2(nref2)

  this is the sample query u could tryout from this query.

  Abhijit - http://abhijitmore.wordpress.com

• Abhijit More

  SSCertifiable

  Points: 6897

  More actions

  September 5, 2008 at 12:30 am

  #867580

  Can you provide the XML ?

  Abhijit - http://abhijitmore.wordpress.com