Hi,
If you're using
SQL Server 2005 or greater, then this should work:
SELECT keyid, field1, field2
FROM (SELECT keyid, field1, field2,
ROW_NUMBER() OVER (PARTITION BY keyid ORDER BY field1, field2) AS RowNumber
FROM fnFunction('PARAMETER')
) AS sub
WHERE sub.RowNumber = 1;
I am assuming that
fnFunction is a table-valued function.