looking good bulk insert xml shredding instance sql 2005


a small assistance needed. i'm receiving an xml record identical this:



<?xml version="1.0" encoding="utf-16"?>
<dc:grantee xsi:schemalocation="http://www.blahblahblah.com/fullschema test.xsd " xmlns:dc="http://www.blahblahblah.com/fullschema" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance">
    <rpgid>90cu0024</rpgid>
    <planid>01</planid>
    <case>
        <caseid>100001</caseid>
        <rpgid>90cu0024</rpgid>
        <file_o>2008-02-08t00:00:00</file_o>
        <adult>
            <adultid>100001a1</adultid>
            <caseid>100001</caseid>
            <aprimary>1</aprimary>
            <arltnshp>bm</arltnshp>
            <adob>1978-12-03t00:00:00</adob>
            <aracai>1</aracai>
            <asex>2</asex>
            <satx>
                <satxid>md2120378</satxid>
                <adultid>100001a1</adultid>
                <saassess>2008-02-22t00:00:00</saassess>
                <pubprvtx>1</pubprvtx>
                <txadmit>2008-02-23t00:00:00</txadmit>
                <txset>5</txset>
            </satx>
        </adult>
        <child>
            <childid>100001c1</childid>
            <caseid>100001</caseid>
            <cindex>1</cindex>
            <chbdate>2008-02-05t00:00:00</chbdate>
            <chsex>1</chsex>
            <chracai>0</chracai>
            <maltx>
                <maltxid>10000023</maltxid>
                <childid>100001c1</childid>
                <rptdt>2008-02-05t00:00:00</rptdt>
                <chmal1>2</chmal1>
             </maltx>
         </child>
    </case>




what i need import bit tables stored proc. i've amateurish anything whole regurgitation examples books online, uh, online. i need small syntax walk-through shows i bulk insert record (using openrowset?) following take information separate relating tables while surpassing keys. seems should easy, nonetheless anxiety component only tough by. i also have opening schema i need explain well.



anybody have good reference?



Comments

Post a Comment

Popular posts from this blog

list macos calm editors formula editors

i searched found maudite's doubt text editors nonetheless windows. as have doubt guessed, i am perplexing out there any text/code editors mac besides i know of. i'll correct post consolidate editors listed. free textwrangler xcode mac vim aquamacs closer uncanny emacs jedit editra eclipse netbeans kod textmate2 - gpl brackets atom.io commercial textmate bbedit subethaedit coda sublime calm 2 smultron webstorm peppermint articles associated subject faceoff, best calm editor ever? maceditors.com, mac editors comforts compared thank everybody total suggestions.
Read more

how hibernate @any-related annotations?

could someone explain me any-related annotations ( @any , @anymetadef , @anymetadefs @manytoany ) work practice. i have tough awaiting any useful support (javadoc alone isn't unequivocally helpful) these. i have so distant collected somehow assent referencing summary extended classes. case, since there an @onetoany annotation? 'any' referring unparalleled 'any', churned 'any'? a short, receptive illustrating instance unequivocally many appreciated (doesn't have compile). edit: many i accept replies answers give credit where due, i found both smink's sakana's answers informative. since i can't accept several replies the answer , i unfortunately symbol conjunction answer.
Read more

using mvc, should hoop communication between views? between models?

question array 3 query morally know mvc before i exercise it: i have twin cases mind: the primary application window needs launch the preferences window. (one view invoking another view.) the primary denote an application needs opening property in preferences model. (one model accessing another model.) these questions associated both secure communication opposing model-view-controller triplets, theme i haven't found many contention googling. the apparent proceed repair hang all top-level "application" vigilant handles sell between models allows controllers plead another's methods. i have seen implemented, nonetheless i'm positive the good idea. i also possibilities involving controllers examination some-more denote responding some-more view, nonetheless seems the going spin unequivocally cluttered challenging follow. suggestions best exercise arrange cross-talk? i feel the unequivocally apparent question, nonetheless i've amateurish well-documented soluti...
Read more