DECLARE @Stats TABLE (PersonID INT, Rank1 INT, Rank2 INT) INSERT @Stats SELECT 1, 6, 7 UNION ALL SELECT 2, 14, 11 UNION ALL SELECT 3, 3, 4 UNION ALL SELECT 4, 1, 2 UNION ALL SELECT 5, 11, 8 UNION ALL SELECT 6, 15, 15 UNION ALL SELECT 7, 4, 1 UNION ALL SELECT 8, 2, 9 UNION ALL SELECT 9, 9, 6 UNION ALL SELECT 10, 10, 10 UNION ALL SELECT 11, 5, 5 UNION ALL SELECT 12, 8, 13 UNION ALL SELECT 13, 13, 12 UNION ALL SELECT 14, 7, 3 UNION ALL SELECT 15, 12, 14 SELECT dbo.Spearman(Rank1, Rank2) FROM @Stats