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 - 2005-03-14 : 08:32:33
|
| Imraan Parker writes "I have two tables. Users and Roles. One user can belong to many roles. I create a view, vUser, that displays all the users and the roles they belong to.The view duplicates a row for each role that the user belongs to.What I would like to do is place a list of the roles in one column of the result, thus only having one row for every user no matter how many roles he or she belongs to.How do I do this?" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
View that displays JOINED table columns as a single column in the row 