markej
asked on
Clearing up data
Hi I have a database Sql Server database with the following sample data (see attached file) I am trying to create a stored procedure that will allow me to just show one record for each person/team position I've included the seasoned for sake of completeness BUT it's not needed. WHAT is needed is however ONLY one id, firstname, surname, teamposition record.
I've tried using a select distinct BUT the multiple ID's wreck this, I need some help on selecting just the 1st copy of each of the multiple records ie instead of having :
24347 2 47 Stewart Clifton 1 2
24348 2 47 Stewart Clifton 1 2
I ONLY want one entry
HELP!
I've tried using a select distinct BUT the multiple ID's wreck this, I need some help on selecting just the 1st copy of each of the multiple records ie instead of having :
24347 2 47 Stewart Clifton 1 2
24348 2 47 Stewart Clifton 1 2
I ONLY want one entry
HELP!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER