query using cursor

[thefrstgatsby]

I want to create a query which takes the following table:

Table 1

Row 1 Row 2
----- -----
one bcf
two wer
three wer
four wer
five xyz


And produces:

tempTable 2

Row 1 Row 2
----- -----

one bcf
two, three, four wer
five xyz


using a cursor or some other way, but it must append Row 1 values that have the same Row 2 values, by using a "," to separate them.

How can I do this?

 

[SQLSister]

Concatenating a one-to-many relationship into a single column
faq183-2146


Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief