Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to use XML data of SQL table column and perform tasks based on tag values. Expand / Collapse
Author
Message
Posted Wednesday, March 20, 2013 11:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 4, 2014 4:43 AM
Points: 19, Visits: 171
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.
Post #1433350
Posted Friday, March 22, 2013 12:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 4, 2014 4:43 AM
Points: 19, Visits: 171
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
Post #1434144
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse