simple query for displaying groups...
I'm a beginner in sqlserver2000.
I have a small question.
I have a small table as follows:
The objective is to display company and its products separated by commas.
I did it by creating a cursor by storing those two values in two temp variables and going row by row appending the characters. Since cursors are said to be slow, can this be done by select statements? I don't want to create another table for the same data this table has.
thank you for any ideas.