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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Duplicated ID merge in a table

Author  Topic 

terrikwei
Starting Member

3 Posts

Posted - 2007-10-09 : 23:20:57
I am currently working to solve this problem that i am facing.
I just cant' get my desired solution to my problem.
As per below is the current db view.
emp_id skill level years remarks
2541 COMPUTER BAIK 1 <null>
2541 WORD PROCESSING BAIK 1 <null>
2541 EXCEL BAIK 1 <null>
2541 POWERPOINT BAIK 1 <null>

how do i get this repeated emp_id to have a view of..

emp_id skill level
2541 COMPUTER.wordprocessin,excel,powerpoint BAIK,baik,baik,baik
years remarks
1,1,1,1 <null>,<null>,<null>,<null>


i just can't seem to get this comin up.. please kind advise
thanks all!

Kristen
Test

22859 Posts

Posted - 2007-10-10 : 00:14:18
Duplicate post: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90746
Go to Top of Page
   

- Advertisement -