Hugo Kornelis (12/28/2014)
Jeff Moden (12/28/2014)
The link for the "poor documentation" that I was speaking of is actually in Books Online under UPDATE... as in "Quirky Update", which can be controlled but is absolutely not supported. Let's not go there, though. 😀I see the similarities between quirky update and aggregate concatenation queries from an "intenedced effect" point of view, but frmo a technical point of view, they are totally different. I don't think it's safe to assume that documentation for the one applies to the other.
That would be part of the reason why I have so much fun at all of this. I don't assume but I do see the similarities and the possible workarounds.
--Jeff Moden
Change is inevitable... Change for the better is not.