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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-02-20 : 08:09:39
|
| Rajesh Agarwal writes "I have a query which returns me a output like this :Col1 Col2Group1 UserAGroup1 UserBGroup2 UserCGroup2 UserDI want some method that should return me the output like this :Col1 Col2Group1 UserA,UserBGroup2 UserC,UserDIf i don't want to use temp tables, is there any other way to accomplish the above.Waiting for ur Reply" |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-02-20 : 08:27:56
|
| There is lots of sample code for this at this site.Search for cross tabs |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
|
|
|
|
|
Using String concatenation as a aggregate function