Hi folks --
I love the SQL Team article on using COALESCE to build comma-delimited strings. Very useful in my work. But I'm running into a situation where I want to use this technique but can't seem to figure out how. Basically, I have a table that looks like this:
And I want to be able to create a SELECT statement whose results look like this:
A 1, 2, 3
B 1, 2, 3, 4
Any ideas on how I can accomplish this?
Thanks in advance.