Thanks for the quick reply, but I was totally unclear as to what I really needed. If you look at the code below I am retrieving this data via...

Thanks for everyone who responded. Looks like based on our needs we will probably just go with a table that gets "refreshed" as needed.

Trying to rank potentially 20k+ records...

Interesting way to create the rankings. Unfortunately this is rather slow even with only 10k records in my table. I will be having at least 20k+ records in...

ECH_Summary DDL

-------------------------------------

CREATE TABLE [dbo].[ECH_Summary] (

[husr_UID] [int] NOT NULL ,

[esum_AtBats] [smallint] NULL ,

[esum_Runs] [smallint] NOT NULL ,

[esum_Hits] [smallint] NOT NULL ,

[esum_Doubles] [smallint] NOT NULL ,

[esum_Triples] [smallint] NOT NULL ,

[esum_Homeruns] [smallint] NOT...