Concluído

Ms SQL Stored Proc parsing XML

I need a stored procedure that can parse an XML file and create an insert statement. I need the ability to pull an XML file from a web service and put two values into a database. Run the following url and you will get the XML file that needs to be parsed

ids=19240239,19788750,19540562,19552937,19552938,20069779,22429209,25057432,25379345,19855374,20051377,20135645,20647337,20670733,20716633,21613377,22044694,22065985,22605570,22887343,23060037,23321855,23489776,23554130,23860400,24008128,24236248,24252368,24388920,24697618,25115686,25605447,25652396,25835512&format=xml

I need to store each value such as PMID, PMCID, DOI, mid

and end up with something like

insert into [[url removed, login to view]] (pmid, PMCID, DOI, mid, VersionPMCID)

select

[url removed, login to view]('') PMID,

[url removed, login to view]('') PMCID,

[url removed, login to view]('') DOI,

[url removed, login to view]('') mid,

[url removed, login to view]('') versionPMCID,

from [[url removed, login to view]] cross apply [url removed, login to view]('') as R(nref)

Habilidades: Microsoft SQL Server , XML

Veja mais: sql server 2000 xml parsing error element closed, ms sql database tally xml tags, sql jsp jdbc xml parsing tools, xml data transfer sql server, xml import 2005 sql, download file stored sql database binary format, sql server export xml, sql charts flash xml, xml path stored procedure, sql export import xml

Acerca do Empregador:
( 91 comentários ) Charleston, United States

ID do Projeto: #8258160

Concedido a:

paskal77

Hello, I am interested in helping develop your project. I can develop your project in C # and Sql server I can process the XML directly from the database or from the frontend and send insert Please talk to th Mais

$25 USD em 1 dia
(13 Comentários)
3.6