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 |
|
funk.phenomena
Posting Yak Master
121 Posts |
 Posted - 2014-12-09 : 14:13:11
|
| Hi all - I have the following table:[CODE]EMP# ID1 ID2 ID3 ID4123 FR64 NULL NULL NULL123 NULL NULL NULL 12GH123 NULL AB46 NULL NULL[/code]I'd like the output to eliminate as much NULLs as possible, and display all the possible "IDs" one on row per employee.[CODE]EMP# ID1 ID2 ID3 ID4123 FR64 AB46 NULL 12GH[/CODE]Any ideas?[CODE]SELECT EMP#, ID1, ID2, ID3, ID4 FROM TABLE T1[/CODE] |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-12-09 : 14:34:41
|
| [code]select emp#, max(ID1) + ',' + max(id2) ...from ..group by emp#[/code] |
 |
|
|
|
|
|
Simple Query Question