Select Query for Table having Multiple Records

[ISChana]

Dear all,
I hv table like this
no name
1 aa
1 bb
1 cc
2 dd
2 ee
3 ff
3 gg
Now I like to write query to get result in this way
no name
1 aa,bb,cc
2 dd,ee
3 ff,gg

So. Pl. Suggest how to do this..

regards

inder

 

[vongrunt]

Check this:

http://www.nigelrivett.net/CSVStringFromTableEntries.html

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]