hey I have an xml file ,
the format of which is something like this :
<xml ?.....................>
<name> anisha </name>
<class> 6 </class>
<id> 13 </id>
<date> xxxx </date>
now I want to extract the data anisha , 13 and 6 and pass these to my SP.
How should I go about it ?
Should I use a staging table where I copy the entire data into the table and then extract it in my SP. Or use a fixed length approach ?