spGet_ATHLETICS_TEAMPAGEOWNER

  CREATE PROCEDURE [dbo].[spGet_ATHLETICS_TEAMPAGEOWNER]
  @TeamID int
  AS
  SELECT
  at.PageCreatorClientUsersID,
  cu.LastName,
  cu.MiddleInitial,
  cu.FirstName
  FROM
  dbo.ATHLETICS_TEAMS at
  inner join dbo.ClientUsers cu
  on at.PageCreatorClientUsersID = cu.ID
  WHERE
  at.ID = @TeamID