OpenXML SQL 2000

• bmahony993

  Right there with Babe

  Points: 762

  More actions

  September 27, 2007 at 12:17 pm

  #70219

  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

• Adrian Nichols-360275

  SSCertifiable

  Points: 7694

  More actions

  October 1, 2007 at 2:38 am

  #737622

  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]