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 |
|
Arun.G
Yak Posting Veteran
81 Posts |
 Posted - 2010-05-26 : 05:52:36
|
| SAMPLE DATA IN MY TABLE:EMPID NAME POSITION ROLEID1 AAA MGR 2,32 BBB TRA 33 CCC EMP 4NOW I WANT THE RESULT LIKE:EMPID NAME ROLES1 AAA FUNHEAD, ADMIN2 BBB ADMIN3 CCC HRINSTEAD OF ROLEID I WANT TO DISPLAY ROLENAME AND THE VALUES SHOULD BE SEPAERATED BY COMMATHE ROLES ARE COMING FROM MASTER TABLE WHICH CONTAINS ROLEID AND ROLENAMEPLS HELP ME TO SOLVE THIS IN QUERY IMMEDIATELY |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-26 : 05:56:03
|
To get the ROLENAME you have to join the MASTER TABLE on ROLEID.The comma separated display should really be done in the front end.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-05-26 : 06:06:23
|
| Also you need to read about normalizationMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
MULTIPLE VALUES