Viewing 15 posts - 8,431 through 8,445 (of 8,753 total)
Grant Fritchey (4/30/2014)
April 30, 2014 at 1:14 pm
Jeff Moden (4/30/2014)
Eirikur Eiriksson (4/30/2014)
INNER JOIN NUMBERS NMON LEN(MT.MYTEMP_STR) <= NM.N
I'm thinking that bit of code cannot possibly be correct even for the old versions.
Thanks Jeff, this I missed!
๐ that...
April 30, 2014 at 12:59 pm
He he, somehow my phone didn't show the earlier reply, kind of awkward :hehe:
My first approach would be creating a table with a different name but same structure, copy the...
April 30, 2014 at 12:22 pm
Quick thought, how about extracting the node to an encrypted table, delete it from the XML and when needed, join the two together?
๐
April 30, 2014 at 11:48 am
SQLdude412 (4/30/2014)
Eirikur Eiriksson (4/30/2014)
To further on Lowell's point, what is the output of "select datalength(xml_column) from bad_table"? Should be about 70% of the nvarchar conversion normally.๐
Thanks for your reply.
The value...
April 30, 2014 at 11:43 am
To further on Lowell's point, what is the output of "select datalength(xml_column) from bad_table"? Should be about 70% of the nvarchar conversion normally.
๐
April 30, 2014 at 11:30 am
Sean Lange (4/30/2014)
Jeremy Brown (4/30/2014)
April 30, 2014 at 9:53 am
Do you have the option of adding a table and use the numeric column to link the two? ASCII code in base 10 is not going to be too useful...
April 30, 2014 at 8:19 am
This should get you started
๐
;with XMLNAMESPACES (
'http://www.abc.com/Details' as qsds)
Select
ID
,Version
,Start_Date
,End_Date
,DE.TAILS.value('Age[1]','varchar(50)') AS Age
,MO.DULE.value('.[1]','varchar(50)') AS MModule
,MD.*
FROM Table1 T1
OUTER APPLY...
April 30, 2014 at 7:03 am
Paul White (4/30/2014)
Eirikur Eiriksson (4/30/2014)
April 30, 2014 at 5:55 am
FYI: ran the test on the CLR Split, mm's memory optimized version and the lead window function version. Hardly any benefit of using the window function, 0.001 on average and...
April 30, 2014 at 4:34 am
April 30, 2014 at 12:39 am
ScottPletcher (4/29/2014)
Simple problems sometimes call for simple solutions. Why over-engineer everything?
I do agree but sometimes I get carried away on the cloud of perfection and everlasting solutions:-P
April 29, 2014 at 1:38 pm
ScottPletcher (4/29/2014)
April 29, 2014 at 1:28 pm
Viewing 15 posts - 8,431 through 8,445 (of 8,753 total)