• Jeff

    Its brilliant. But how on earth can anyone be expected to figure out the STUFF(... WHERE ... FOR XML PATH('') Syntax - especially when there is no XML involved!

    I'll be using this, but I'm a bit wary as I don't know exactly how it works