Excluding repeating values in a stored procedure

[maha2886]

The scenario is as follows:

I have to write a sql query which generates the result in the following form.


User ID Langauge Technology PM
ABC English C# XYZ
Hindi Sql LMN
Sanskit IJK
BCD




Please see the attachment

In the DB i have mapping between UserID and Langauge, Name and Technology and so soon.

So in DB the data for the UserID and Language mapping(keys) would be like

ABC English
ABC Hindi
ABC Sanskrit

same for technology and PM

How can i write a query so that i can get the data in above mentioned form.

Any help would be appreciated.

Thanks

[ck9663]

It would be better if you handle it on your front-end...

Good Luck!!!

~~CK