I want my out put to be like this.

See more:

SQL-Server-2005

SQL-Server

Hello,

Can you tell me how to display different values of rows in one row.

Suppose my output is something like this:

id    name    marks
001    abc     23
001    abc     25
001    abc     20
001    abc     24
001    abc     28
002    def     19
002    def     25
002    def     26

and my expected output is this:

id    name    marks
001   abc     23,25,20,24,28
002   def     19,25
003   acs     26,20,22

Please tell me how do i write the procedure query..?
can you give me an example for the above question...??


[edit]Code block added, "Ignore HTML..." option disabled - OriginalGriff[/edit]