/************************************************************
 * Code formatted by SoftTree SQL Assistant © v6.2.112
 * Time: 11/16/2012 8:00:29 AM
 ************************************************************/
-- 1
SELECT Gender,
       GivenName,
       Surname
FROM   HugeNames
WHERE  NameID IS NOT     NULL
GROUP BY
       Gender,
       GivenName,
       Surname

-- 2
;WITH cte
AS
(
    SELECT GivenName,
           Surname,
           MiddleInitial,
          NameID,
           ROW_NUMBER() OVER 
			( PARTITION BY GivenName,Surname,MiddleInitial ORDER BY (SELECT NULL) ) AS RN
    FROM   HugeNames
    WHERE  RTRIM(LTRIM(GivenName)) LIKE '%%'
           AND NameID IS NOT NULL
           AND LTRIM(RTRIM(Surname)) LIKE '%%'
           AND GivenName IS NOT NULL
           AND Surname IS NOT NULL
) 
SELECT u.GivenName,
       u.Surname,
       NameID,
       u.MiddleInitial
FROM   cte
WHERE  RN = 1
ORDER BY
       GivenName,
       Surname,
       MiddleInitial ASC