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
June 10, 2005 at 4:28 pm
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.
DECLARE @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>'
xmlns:n="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="'" target=_blank>http://www.xbrl.org/us/fr/common/pte/2005-02-28"/>'
(
BasicNetIncomePerOrdinaryShareAndAds,
CostGoodsServicesSold
)*/
BasicNetIncomePerOrdinaryShareAndAds,
CostGoodsServicesSold
(
BasicNetIncomePerOrdinaryShareAndAds smallmoney 'bobj:BasicNetIncomePerOrdinaryShareAndAds',
CostGoodsServicesSold money 'usfr-pte:CostGoodsServicesSold'
)
GO
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply