how can i get the comma seperated values

i have a table like this

ID Value
1 A
1 B
1 C
2 D
3 E
4 F
5 G


I WANT THE RESULT LIKE THIS

ID VALUE
1 A,B,C
2 D,E,F,G


CAN ANYONE HELP ME

__________________
SQL Technical Consultant

http://www.sqlteam.com/item.asp?ItemID=256


Not a good idea to ask question that you already know answer...

Yes, you got to stick to such stored procs, there is no any such defined method of doing that. May be you can search on it in this forum. This was discussed a long back here. (search for Jeff Mason's posts, you will find one)

_________________________
- Vijay G
Strive for Perfection