How to read Multiple Rows Data into single Record or String.

[patiya]

Hellow Folks.

Here is the Original Data in my single SQL 2005 Table (Common Column is Department# in rows):

Department: Sells:
1 Meat
1 Rice
1 Orange
2 Orange
2 Apple
3 Pears

The Data I am expecting separated by Semi-colon:

Department: Sells:
1 Meat;Rice;Orange
2 Orange;Apple
3 Pears

I would like to read my data via SP or CLR or VStudio 2005 Page . Any help will be appreciated. Thanks..

 

[chamilz]

below threads would help you..

thread183-1403757
thread183-1427768