My select statement returns two columns, ContactID and IndividualID. Any given IndividualID will have 1 or more ContactID. In the cases where there is more than one, how can it return only 1 ContactID per IndividualID? It doesn't matter if it's always the first ContactID per IndividualID or a random one.

SELECT IndividualID, MAX(ContactID) FROM Table1 GROUP BY IndividualID ORDER BY IndividualID

Aw geez, that was easy. Thank you very much! How about making it pick a random one for bonus points?

It's doable, but takes a lot of resources from the server.

SELECT i.IndividualID, (SELECT TOP 1 t.ContactID FROM Table1 AS t WHERE t.IndividualID = i.IndividualID ORDER BY NEWID())
FROM (SELECT IndividualID FROM Table1 GROUP BY IndividualID) AS i

Would making it do this via a function or stored procedure be too much to ask (I know you can't call NEWID in a function)?