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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy