How to use XML data of SQL table column and perform tasks based on tag values.

• connect.akshay

  Say Hey Kid

  Points: 667

  More actions

  March 20, 2013 at 11:04 am

  #272372

  Hi Guys.

  I need some help. I am suppose to get XML data from column of a table. The XML data has many tags. One of the tag contains values like

  <Code date= 30/03/2013>

  <apr id =1> -2 </apr>

  <rdv id =2> 1 </rdv>

  </code>

  I need to run a particular task which checks the date. Like if today's date= (Code date -2) or

  today's date = (code date + 1)

  run a mailer task.

  How should i go about it ? Please forgive me for the XML data format. I am naive in XML.

• connect.akshay

  Say Hey Kid

  Points: 667

  More actions

  March 22, 2013 at 12:34 am

  #1599675

  Praveen posted a solution for this.

  http://stackoverflow.com/questions/15529842/how-to-use-xml-data-of-sql-table-column-and-perform-tasks-based-on-tag-values