Viewing 15 posts - 121 through 135 (of 253 total)
drew.allen (11/25/2016)
Have you tried adding a ROOT directive? That seems to remove most of the xmlns prefixes, but it may not give you the structure that you need.Drew
Thank you...
November 25, 2016 at 11:19 am
Eirikur Eiriksson (11/25/2016)
Can you post an example of the XML please?😎
Sure!
This is the valid example as of EHFstandards
This is my test in SQL, where I provide for now...
November 25, 2016 at 8:16 am
Eirikur Eiriksson (11/25/2016)
BOR15K (11/25/2016)
Not sure I understood you - it will show xmlns='*' then, no?
Not what I meant
😎
To clarify, skip this
WITH XMLNAMESPACES (
'urn:digi-inkoop:ubl:2.0:NL:1.6:UBL-NL-CommonBasicComponents-2' AS [nl-cbc],
'urn:un:unece:uncefact:data:draft:UnqualifiedDataTypesSchemaModule:2' AS udt,
'urn:oasis:names:specification:ubl:schema:xsd:CommonExtensionComponents-2' AS ext,
'urn:oasis:names:specification:ubl:schema:xsd:CommonBasicComponents-2'...
November 25, 2016 at 7:59 am
drew.allen (11/25/2016)
The xlmns is being included because you've specified the XSINIL directive. If you don't want it included, you'll have to get rid of the XSINIL directive.Drew
The result is...
November 25, 2016 at 7:52 am
Not sure I understood you - it will show xmlns='*' then, no?
November 25, 2016 at 7:16 am
TheSQLGuru (11/1/2016)
BOR15K (11/1/2016)
Luis Cazares (11/1/2016)
If you have 9 million rows, int can handle them perfectly. Unless you have a random sequence
Sadly you're right - every new customer starts from 2...
November 1, 2016 at 11:06 am
Luis Cazares (11/1/2016)
If you have 9 million rows, int can handle them perfectly. Unless you have a random sequence
Sadly you're right - every new customer starts from 2 to 3...
November 1, 2016 at 10:35 am
Luis Cazares (11/1/2016)
On the other...
November 1, 2016 at 9:48 am
Perhaps UDFtest.UDF2 = COALESCE(UDFIn.UDF2,UDFtest.UDF2) ? If UDFIn.UDF2 is null then it will use the original value of your UDFtest
November 1, 2016 at 9:34 am
Thank you. I thought it would be that way 🙂
September 21, 2016 at 8:41 am
Hello,
Can one advise how to obtain file's details, please? Both xp_dirtree and xp_cmdshell return expected list of files, but I also need their properties: size and date.
Is it possible, please?...
September 20, 2016 at 3:08 am
Thank you, Lowell!
It did the trick!
June 13, 2016 at 11:16 am
Sorry to revive this topic, but I have a same issue but neither CONVERT (VARCHAR(MAX)... nor master.dbo.fn_varbintohexstr worked for me.
two examples I have in SQL:
0x24005472616E73616374696F6E2046656520666F7220466C6967687420506167652020202031
I know it means "Transaction Fee...
June 13, 2016 at 10:50 am
Viewing 15 posts - 121 through 135 (of 253 total)