Turn column of values into delimited list as field
-
I have a parent table Item and a child table Grade. For a query, I would like to be able to select from a view or function that gives me one Item per row (as if I were selecting right from it) but adds an ntext column to the output, where its child Grades are listed in a delimited list. I'm not entirely sure where to go with this, without making it too terribly complicated. Please advise?
-
I have a parent table Item and a child table Grade. For a query, I would like to be able to select from a view or function that gives me one Item per row (as if I were selecting right from it) but adds an ntext column to the output, where its child Grades are listed in a delimited list. I'm not entirely sure where to go with this, without making it too terribly complicated. Please advise?