Search results for query: *

> >I hope I didn't say anything that may have offended you. > Oh gosh, not at all. I just had to laugh when I saw the statistics on the timings of the functions... 21573 vs 1796... Eek! Anyway, thanks for your kind words. Best... --Brad

LOL... I'm not surprised at the timing results of the various PROPER functions. I mainly wrote the functions I wrote as a quick exercise (and mainly so that I could utilize them in my Random Sentence Generator). I didn't put a lot of thought into making them as speedy as possible. I like...

Sorry... I just saw my message... Those REPLACEs should read: , '& amp ;','&') , '& lt ;','<') , '& gt ;','>') --Brad

As far as I can tell, the only characters that are encoded (unless you perhaps have to deal with obscure NVARCHAR characters) are ampersand, less-than, and greater-than, as you can see when you look at the output of this: with Chars as ( select [Char]=char(Number) from master..spt_values...

I have an app in the blog that tells me where people come from. I saw that people got to the "XML Paths of Glory" blog post from this thread in tek-tips, so I decided to come here to see what pointed them in that direction. (Thanks for the kind words, BTW).

Thanks for the link to the blog, markros. The one where I talk about eliminating the XML encoding is this one, though: http://bradsruminations.blogspot.com/2009/10/making-list-and-checking-it-twice.html However, the blog entry talks about eliminating the encoding for the purposes of creating...