OpenXML and namespaces

Question

OpenXML and namespaces

Old Hand

Points: 360

June 10, 2005 at 12:14 pm

It seems like this should work, but it doesn't return the value, just Null instead.What am I missing here?Thanks,Paul========================================DECLARE @iDoc intDECLARE @Form_10Q varchar (2000)SET @Form_10Q ='<?xml version="1.0" encoding="us-ascii"?><!--XBRL document created with Dragon Tag (TM) XBRL Enabler by Rivet Software version 1.5.0.5--><!--Based on XBRL 2.1--><!--Created on: 5/5/2005 10:00:36 PM--><xbrl xmlns="http://www.xbrl.org/2003/instance" xmlns:link="http://www.xbrl.org/2003/linkbase" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:bobj="http://www.businessobjects.com/bobj/2005-05-04" xmlns:iso4217="http://www.xbrl.org/2003/iso4217" xmlns:xbrli="http://www.xbrl.org/2003/instance" xmlns:usfr-pte="http://www.xbrl.org/us/fr/common/pte/2005-02-28">  <link:schemaRef xlink:type="simple" xlink:href="bobj-20050504.xsd" />  <bobj:BasicNetIncomePerOrdinaryShareAndAds contextRef="JanMar2004" unitRef="USDEPS" decimals="2">0.04</bobj:BasicNetIncomePerOrdinaryShareAndAds>  <usfr-pte:CostGoodsServicesSold contextRef="JanMar2004" unitRef="USD" decimals="-3">49312000</usfr-pte:CostGoodsServicesSold></xbrl>'EXECsp_xml_preparedocument @iDoc OUTPUT,  @Form_10Q, '<root  xmlns="http://www.xbrl.org/2003/instance" xmlns:link="http://www.xbrl.org/2003/linkbase" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:bobj="http://www.businessobjects.com/bobj/2005-05-04" xmlns:iso4217="http://www.xbrl.org/2003/iso4217" xmlns:xbrli="http://www.xbrl.org/2003/instance" xmlns:usfr-pte="http://www.xbrl.org/us/fr/common/pte/2005-02-28"/>'BEGIN TRANSACTIONINSERT INTO Form_10Q_SingleTable(BasicNetIncomePerOrdinaryShareAndAds,CostGoodsServicesSold)SELECT BasicNetIncomePerOrdinaryShareAndAds,CostGoodsServicesSoldFROMOPENXML(@iDoc, 'xbrl', 2)WITH( BasicNetIncomePerOrdinaryShareAndAds smallmoney 'bobj:BasicNetIncomePerOrdinaryShareAndAds',CostGoodsServicesSoldmoney  'usfr-pte:CostGoodsServicesSold')COMMITEXEC sp_xml_removedocument @iDocGO

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

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

Paul Kloepper Old Hand Points: 360 More actions · Answer 1

I have an OpenXML stored procedure with multiple namespaces that executes fine when performing a Select only, but when I add in an Insert statement, it gags horribly and afterward I can't even Drop the table from the database (the table is ruined in some irrecoverable way). My main goal here is to insert the xml data into the sql table.

Thank you,

Paul

------------------------------------------------------------------------------------------

Here's the sproc (with the offending INSERT INTO commented out):

DECLARE @iDoc int

DECLARE @Form_10Q varchar (2000)

SET @Form_10Q ='

<?xml version="1.0" encoding="us-ascii"?>

<xbrl xmlns="http://www.xbrl.org/2003/instance"