Viewing 15 posts - 271 through 285 (of 6,486 total)
March 21, 2017 at 11:01 am
Also in the "food for thought" category - you apparently have local access to the actual schema driving these messages. The schema would have all of the fields (optional or...
March 21, 2017 at 10:51 am
Note: your sample XML is missing a closing > on one of your Classification elements.
Adapting the previous example code to a table containing one or more of your...
March 20, 2017 at 11:50 am
Basically It's a two step process:
1. Affix the query that has the
xmlcolumn.node('/somexpath','type')
syntax in it with an appropriate WITH XMLNAMESPACES expression
2. incorporate the namespace alias into...
March 20, 2017 at 10:45 am
March 20, 2017 at 8:10 am
March 19, 2017 at 4:47 pm
Don't let the intro to the intro put you off too much (I...
March 19, 2017 at 1:19 pm
March 18, 2017 at 6:02 pm
Lynn - If you need a hand with XML - post it and will take a gander at it.
March 18, 2017 at 8:21 am
declare @x xml;
set @x='<product-lineitems>
<product-lineitem id="1">
<net-price>44.54</net-price>
<tax>4.46</tax>
<gross-price>49.00</gross-price>
<base-price>49.00</base-price>
<lineitem-text>pendant</lineitem-text>
<tax-basis>49.00</tax-basis>
<position>1</position>
<productid>LBPE0001-001-12</productid>
<product-name>pendant</product-name>
<quantity unit="">1.0</quantity>
<tax-rate>0.1</tax-rate>
<shipment-id>00134005</shipment-id>
<gift>false</gift>
<custom-attributes>
<custom-attribute attribute-id="ean">4051245264135</custom-attribute>
March 16, 2017 at 9:35 pm
March 15, 2017 at 4:15 pm
Are you sure that SSIS is the problem? Excel routinely changes the number formatting as you open a file. The earlier example didn't actually look like you "lost any accuracy". ...
March 14, 2017 at 8:28 pm
March 14, 2017 at 6:05 pm
https://msdn.microsoft.com/en-us/library/mt163865.aspx
It's a much more secure version of encrypted data baked into...
March 14, 2017 at 7:05 am
March 13, 2017 at 8:33 pm
Viewing 15 posts - 271 through 285 (of 6,486 total)