Is this what you are after?

CREATE TABLE #Scores(

TID int identity(1,1),--PK

ID int,

Score int)

INSERT INTO #Scores(ID,Score) SELECT 1,10

INSERT INTO #Scores(ID,Score) SELECT 2,5

INSERT INTO #Scores(ID,Score) SELECT 2,15

INSERT INTO #Scores(ID,Score) SELECT 2,25

INSERT INTO #Scores(ID,Score)...

To Elaborate...

I want to create a stored procedure or function that would create a temp table from CROSSJOIN or INNER JOIN and a WHERE of two tables. Then, on that...