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 |
|
le_sloth
Starting Member
1 Post |
 Posted - 2003-02-18 : 06:13:37
|
| HiI'm sure this question has been answered many times before, but i've had noluck finding an answer yet!I have one stored procedure (sp_GetUserRolesList) that returns a string(RoleList) containing the groups that a user belongs to e.g. 'Clients,Admins, Testers'. This procedure has one param - UserID.I have another procedure, GetAllUserDetails, that i want to return columns:Users.UserName, Users.UserCompany etc. (from Users table) and RoleList (fromsp_GetUserRolesList).The data i want would be something like:UserName | UserCompany | RoleListFred | ACME | Clients, TestersBill | Connex | ClientsJon | ACME | Admins, TestersHow do i go about doing this? I've looked all over the place, am i supposedto use a temp table?Seems like such a simple problem!thanks in advanceRik(using SQL Server 2000 SP3) |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-02-18 : 16:54:11
|
| http://www.sqlteam.com/SearchResults.asp?SearchTerms=csv |
 |
|
|
|
|
|
calling one stored procedure from another