Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kmmchan
Starting Member
5 Posts |
 Posted - 2006-03-07 : 04:23:40
|
| HiI am using SQL Server 2000create table Fac(facility varchar(25))Insert into Fac Values('A')Insert into Fac Values('B')Insert into Fac Values('C')Insert into Fac Values('D')I want to display all the records in Fac table as the format belowFac=============='A','B','C','D'thanks in advance-k |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-07 : 05:52:57
|
| Note that if the combined string exceeds 8000 characters, you need to use more variables. Where do you want to show these data?MadhivananFailing to plan is Planning to fail |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
|
|
|
How to display column as a row