spGetTeamRecord

                 CREATE PROCEDURE [dbo].[spGetTeamRecord] (@TeamID INT, @Category UNIQUEIDENTIFIER, @NumOfEvents INT) AS
                 SET NOCOUNT ON

                 SELECT SUM(CASE ScoreOutcome WHEN 1 THEN 1 ELSE 0 END) Wins,
                     SUM(CASE ScoreOutcome WHEN 2 THEN 1 ELSE 0 END) Losses,
                     SUM(CASE ScoreOutcome WHEN 3 THEN 1 ELSE 0 END) Ties
                 FROM dbo.CalendarEvent ce
                     INNER JOIN dbo.ATHLETICS_EVENTS ae
                         ON ce.AthleticEventID = ae.ID
                 WHERE TeamID = @TeamID
                     AND Category = CAST(@Category as nvarchar(100))

                 SET ROWCOUNT @NumOfEvents

                 SELECT BeginDate Date,
                     Title Name,
                     cte.Description Opponent,
                     Score,
                     ScoreOutcome
                 FROM dbo.CalendarEvent ce
                     INNER JOIN dbo.ATHLETICS_EVENTS ae
                         ON ce.AthleticEventID = ae.ID
                     LEFT OUTER JOIN dbo.SiteCodeTableEntries cte
                         ON cte.EntryGUID = ae.OpponentID
                 WHERE TeamID = @TeamID
                     AND Category = CAST(@Category as nvarchar(100))
                     AND ISNULL(Score, '') <> ''
                     order by BeginDate desc

                 SET ROWCOUNT 0