supermatchgame
Programmer
Hi,
I have some data in SQL that looks like this:
What I would like to do is to get this all into one row, similar to this:
Can anyone suggest a way of doing this using T - SQL?
I have some data in SQL that looks like this:
Code:
ID | FORENAME | SURNAME | ALTERNATIVENAME
1 | JOHN | BLOGGS | DENNIS
1 | JOHN | BLOGGS | FRANKWhat I would like to do is to get this all into one row, similar to this:
Code:
ID | FORENAME | SURNAME | ALTERNATIVENAME1 | ALTERNATIVENAME2
1 | JOHN | BLOGGS | DENNIS | FRANKCan anyone suggest a way of doing this using T - SQL?