Thank you all for the input and assistance.

I understand that an iTVF is better; however, I have no experience using them. I have read about them and attempted to implement it, but it was not working...

@sergiy

I tried your approach, and it kind of mostly works. The issue I am running into is that the "early" times will all be at the front...

Based on the feedback in this thread, I have changed the SPs to UDFs and am using a view instead of calling the NEWID() and RAND() functions directly.

CREATE VIEW vSeedData

AS

SELECT...

Correct me if I am wrong, but I am unable to use NEWID() and RAND() functions in UDFs.

I meant to say there should be one row per CharacterName per calendar month.

Example output: http://imgur.com/wbCO78F

Actual Execution Plan: http://s000.tinyupload.com/download.php?file_id=76029707988028268110&t=7602970798802826811042019

I will provide the other information...

Basically, there should only be one row per month-year. I want to know the pointsEarned/maxPoints for a given calendar month.