lyric0n
Technical User
- Dec 28, 2005
- 74
Hello,
I need to have data split, but apparently SQL doesn't support this by default. Below is an example of what I have and need...
IDKey | EmpID
1 | 101
2 | 101,102
3 | 103
4 | 101,103
...
What I need returned is just a list of unique employee ID's, so just a list of 101,102, and 103.
I've tried tinkering with sub-select statements, but without much luck..Any help is appreciated, thanks,
Chris
I need to have data split, but apparently SQL doesn't support this by default. Below is an example of what I have and need...
IDKey | EmpID
1 | 101
2 | 101,102
3 | 103
4 | 101,103
...
What I need returned is just a list of unique employee ID's, so just a list of 101,102, and 103.
I've tried tinkering with sub-select statements, but without much luck..Any help is appreciated, thanks,
Chris