Updating content in the XML field from another table

• tse.dba

  Newbie

  Points: 5

  More actions

  June 25, 2009 at 2:57 pm

  #133450

  Hi experts,

  I am new to the XQuery, SQLXML technology and I am not sure were I should start looking with my problem. here is what I am dealing with:

  I have a web application developed in ASP, and there is a report page that gets data from the SQL database and form a XML document (this steps has to be done through the ASP page because we have to render the data). Then some of the data in this XML document will be updated based on the values in another table. The XML will then be rendered with XSL and display the report on screen.

  Right now, we are just looping through the first XML document and get the updated data from another table one by one, then update the values in the first XML document. This apporach is very slow and the application got timeout all the time. I think thinking to improve this process.

  I am hoping there is a better and more efficient way to do this.

  Any idea will be greatly appreciated

  Thanks,

  Sam

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  July 20, 2009 at 4:30 am

  #1026843

  Could you provide a sample illustrating what you need to do?

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com