3
Answers

How to get data from XML and send it into table

rachit sharma

rachit sharma

11y
1.3k
1
Want to get values Coming in XML format using stored procedure. The values i am getting are like in the format as mentioned below . What i am trying to do is to just create a table in database as 'RecordsDB' and using Stored procedure parsing the XML, inserts the value in 'Records'. I am trying to search question like this on stack overflow and net but not getting answer ,only knows the mini way is to read the node value like line.column.value(something). But i do have some thousands of records coming from ASP.NET web service.*

  <Root>                        (Root node)
       <Record>                    (Secondary node)
         <Name> A </Name>           (Child node1)
          <Age> 21 </Age>            (Child node2)
       </Record>
         <Record>
         <Name> b </Name>
          <Age> 22 </Age>
       </Record>
      </Root>

How to meet the task? Thanks.

Answers (3)
1
Ben Chris
35 5.5k 1.1m 8y
your issue here is that you are comparing dates valus exactly with the designated columns and I am assuming that your table date column is of datetime type. This means you need to discard time part from both your target column and your from and to dates i.e.
 
 
  1. select * from tablename where DATEADD(dd,0,DATEDIFF(dd,0,date )) between DATEADD(dd,0,DATEDIFF(dd,0,'01-12-2016')) AND DATEADD(dd,0,DATEDIFF(dd,0,'01-02-2017')) 
Accepted
1
Rajeev Punhani
NA 4.7k 402.7k 8y

Hi Vinay,

 Please find the below link.

https://www.codeproject.com/tips/355235/how-to-search-between-two-dates-and-get-all-record 
1
Amit Gupta
NA 16.5k 25.7k 8y
@Vinay
 
It has always been observed for many times that the problem is occuring with only the date formats
 
Always use the universal format 'yyyy-MM-dd' format instead using 'MM-dd-yyyy'. You can change its format whichever suits the clients.
 
try searching like this
 select * from tablename where date between '2016-12-01' and '2017-02-01'
 
1
Catcher Wong
NA 4.5k 188.6k 8y
Hi , 
 
I can not  understand you question clearly ! Do you mean that?
 
1
Ramesh Palanivel
NA 9.5k 138.6k 8y
HI Vinay,
 
Try your code first in your DB, if it is working fine , check whether the DB and system format both are same or not.
 
try this URL, It may help you
 
http://stackoverflow.com/questions/14353434/selecting-data-between-2-dates 
 
http://stackoverflow.com/questions/16447877/c-sharp-between-two-dates-search
 
http://stackoverflow.com/questions/35272405/how-to-search-between-two-dates-in-c-sharp-with-ms-access
 
http://www.c-sharpcorner.com/forums/search-between-two-dates