OpenXML SQL 2000

  • I have a stored proc that, up until now, has been running fine. It takes data from a local Access table and imports into SQL 2000 table. However, this has been working because I didn't have any Null data to deal with. How can I get the following to still work if some of the fields are Null?

    EXEC sp_xml_preparedocument @iDoc OUTPUT,@strXML

    INSERT INTO _allproj(ProjID,Yr,Title,Bud_Cat,Bud_Cat2, Bud_Cat3,RPM,PADM,ABC,Team,Proj_grp,Prg_Goal,Class,Notes,Last_Chg,RevCalc,ABC_Office,Calc_True)

    (SELECT * FROM OpenXML(@iDoc, 'dataroot/temp_allproj',3) WITH _allproj )

    EXEC sp_xml_removedocument @iDoc

  • Hi,

    Have you got an example of the xml you're using to populate the table? :hehe:



    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply